Calculated table joins are used to couple two or more tables of data. Common examples include CROSSJOIN, UNION, EXCEPT and INTERSECT. Common Use Cases for Calculated Table Joins in Power BI Blending or combining data across multiple tables. Creating advanced calculations like new vs. returning users or repeat purchase behavior. Querying tables to troubleshoot errors […]
Posts Tagged ‘PerficientGDCNagpur’
Filters and Types of Filtering in Power BI
Power BI filters are useful tools for organizing data, visualizing and comparing your data visualizations, and creating reports. They are utilized to sort data according to a chosen condition. Filter Types : Visual Level Filter Page Level Filter Report Level Filter Drill Through Filter On the right side of the dashboard, locate the Filter Pane. […]
Relationship Functions in Power BI
Relationship functions in Power BI allow you to access fields within DAX measures or calculated columns through either physical or virtual relationships between tables. Common Use Cases for Relationship Functions in Power BI Defining calculated columns or measures using fields from related tables. Handling relationships between calendars and multiple date fields (transaction date, stock date, due […]