Model
Configure table & Columns
- Row Labels : you set this property for copilot or data model to recognise that is your main column to use.
- Column id: Tell the model to use this for indexing
https://blog.crossjoin.co.uk/2024/08/25/tuning-power-bi-copilot-with-row-labels-and-key-columns/
Create Basic Measures
Relationships
Bi Directional
https://learn.microsoft.com/en-us/power-bi/guidance/relationships-bidirectional-filtering
DAX
- Time Intelligence Functions
- SAMEPERIODLASTYEAR
https://learn.microsoft.com/en-us/dax/sameperiodlastyear-function-dax
https://radacad.com/dateadd-vs-parallelperiod-vs-sameperiodlastyear-dax-time-intelligence-question/
- DATEADD
https://learn.microsoft.com/en-us/dax/dateadd-function-dax
- SUMMARIZE, ROLLUP & ROLLUPGROUP
https://learn.microsoft.com/en-us/dax/summarize-function-dax
https://www.sqlbi.com/articles/all-the-secrets-of-summarize/
- FIRSTDATE & LASTDATE
https://learn.microsoft.com/en-us/training/modules/dax-power-bi-time-intelligence/3-calculations
- USERELATIONSHIP
Do following exercise
https://learn.microsoft.com/en-us/training/modules/design-scalable-semantic-models/
- FILTERS
Calculation Groups
Optimization Tools
a)