Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have a table with revenue records and I'm using the slicer to filter this table, the slicer records contain the period month like this: (Jan 18, Feb18 ...Dec19).
I need to bring the same revenue records for the previous month on the same table. As Follow:
I've tried to write the below measure for the previous month column, but it’s not returning any records:
Measure = var x = ‘Periods’ [Period Num]
return CALCULATE (‘Revenue’[Amount], ‘Periods’[Period Num]=x-1 )
The Periods table is as follow:
Solved! Go to Solution.
Hi @wejdan
You might find this Blog Post helpful.
https://community.powerbi.com/t5/Community-Blog/Relative-Date-Dimension/ba-p/779039
Hi @wejdan ,
If you are looking for a caluclation for Previous timeperiod based on the timeperiod selected in your slicer, refer PREVIOUSMONTH DAX functions:
https://docs.microsoft.com/en-us/dax/previousmonth-function-dax
You can also check for similar Time Intelligence DAX functions.
https://docs.microsoft.com/en-us/dax/
Thanks,
Pragati
Hi @wejdan
You might find this Blog Post helpful.
https://community.powerbi.com/t5/Community-Blog/Relative-Date-Dimension/ba-p/779039
User | Count |
---|---|
42 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |