Power BI Tips

https://www.daxpatterns.com/parent-child-hierarchies/  

https://www.daxpatterns.com/comparing-different-time-periods/  

https://www.daxpatterns.com/static-segmentation/ Note on circular dependency - use DISTINCT instead of VALUES.

https://www.daxpatterns.com/currency-conversion/  

https://www.daxpatterns.com/parent-child-hierarchies/  

https://www.daxpatterns.com/hierarchies/  

  https://www.daxpatterns.com/like-for-like-comparison/

  https://www.daxpatterns.com/comparing-different-time-periods/

https://www.daxpatterns.com/week-related-calculations/  

https://www.daxpatterns.com/parameter-table/   Use slicer to select whether to optionally divide sales amount by 1,000 or 1,000,000. Scale Table - show Scale string in slicer Scale = DATATABLE ( "Scale", STRING, "Denominator", INTEGER, { { "Units", 1 }, { "Thousands", 1000 }, { "Millions", 1000000 } } ) Measure - divide sales amount by Denominater for the slicer string selected. Use 1 if nothing selected or multiple selections. Sales Amount = VAR RealValue = SUMX ( Sales, Sales[Quantity] * Sales[Net Price] ) VAR Denominator = SELECTEDVALUE ( Scale[Denominator], 1 ) VAR Result = DIVIDE ( RealValue, Denominator ) RETURN Result