Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I've seen several topics on this but none seem to cover what I want.
I am using the following formula to calculate a MoM variance
MOM_zero_res_total = (IFERROR([Zero%_Total]/CALCULATE([Zero%_Total],PREVIOUSMONTH('CALENDAR'[Date]))-1,BLANK()))
Currently it is showing blanks (see below). CALENDAR is a calendar table in the background. Zero%_total is a calculation resulting in a %. Note I am expecting the table to show -19.2% for January as that is the 29.4% for January compared to the 36.4% of December.
How do I get this?
Hi @Stroop,
Please share a dummy sample. The pbix file would be great if you can share it. The solution (or cause) bases on the model structure.
Best Regards,
Dale
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |