Posts

Showing posts with the label CALCULATED TABLE

Design Patterns for Calculated Tables in Power BI

  https://www.mssqltips.com/sqlservertip/4945/design-patterns-for-calculated-tables-in-power-bi/
Post a Comment
Read more

Using a Calculated Table to Populate the Rows in a Matrix

The calculated table is related to the Financial Summary table via the Fi nancialSummaryLineTypeId column. The Destination Category column is added to the rows in a Matrix to summarize the measures Sales Detail Destination Categories = UNION(     CALCULATETABLE(         SELECTCOLUMNS(             'Financial Summary Line Type',             "FinancialSummaryLineTypeId", 'Financial Summary Line Type'[FinancialSummaryLineTypeId],             "Destination Category", 'Financial Summary Line Type'[Destination Category]         ),         'Financial Summary Line Type'[Destination Category] IN { "Carry Out", "Delivery", "Dine In", "Drive Thru" }     ),  ...
Post a Comment
Read more

Scenarios of Using Calculated Tables in Power BI

  https://radacad.com/scenarios-of-using-calculated-tables-in-power-bi
Post a Comment
Read more

Scenarios of Using Calculated Tables in Power BI

  https://radacad.com/scenarios-of-using-calculated-tables-in-power-bi Customer Sales = SUMMARIZE(FactInternetSales,FactInternetSales[CustomerKey], 'Total Sales', SUM(FactInternetSales[Total Sales])) Top 10 Customers = TOPN(100,'Customer Sales','Customer Sales'[Total Sales],DESC)
Post a Comment
Read more

Create Calculated Table to Populate/Filter Slicer

https://radacad.com/filtering-slicer-resolved-in-power-bi  
Post a Comment
Read more