Power BI — Hard
Key points
- AVERAGEX is used for calculating the average of an expression over a table.
- DATESINPERIOD generates a table of dates within a specified period.
- Incorrect use of CALCULATE and MOVINGAVERAGE can lead to wrong results.
- PREVIOUSMONTHS does not provide the moving average.
Ready to go further?
Related questions