When creating measures often the time aspect is repeated for each one. Make a measure, then make the YTD and PY versions. There must be a better way!
In this episode Sam learns about Calculation groups and how they can reduce the word load!
Link to SQLBI:
sqlbi.com/tools/
Short files:
wiseowl.co.uk/power-bi/shorts/power-bi/calculation_group/
- DAX: Better measures with Calculation Groups ( Download)
- REDUCE the # of measures with Calculation Groups In Power BI ( Download)
- How to set up and use Calculation Groups in DAX | Power BI ( Download)
- Using calculation groups to selectively replace measures in DAX expressions ( Download)
- Reduce the Amount of Measures You Write w/ DAX Calculation Groups | Power BI DAX Tutorial ( Download)
- Calculation Groups To Your Rescue - DAX Tutorial ( Download)
- Measures vs. calculated columns in DAX and Power BI ( Download)
- Using calculation groups in DAX ( Download)
- Learn methods to exclude measures in calculation groups with DAX functions and Field Parameters ( Download)
- Nashville Power BI User Group (Dec 2020) | Using Calculation Groups in Dax ( Download)
- Scripting syntax for DAX calculation groups ( Download)
- Getting Started with Calculation Groups in Power BI ( Download)
- DAX Calculation groups at the PBI User Group ( Download)
- Power BI Calculation Groups Made Easy: Streamlining KPIs with Less DAX! ( Download)
- Leverage Calculation Groups in Power BI to create a single DAX measure for role playing tables! ( Download)
