Forum Discussion
Month on Month Difference
Hi dommyw277
I have attached the PBIX file at the end of the reply, which you can download and open to check the difference with your own file.Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi dommyw277
Based on your needs, I have created the following table.
Then you can use the following measure to calculate the monthly difference:
Measure =
var _current_month = MONTH(SELECTEDVALUE('Table'[Date]))
VAR _current_billing = CALCULATE(SELECTEDVALUE('Table'[Billing]),FILTER(ALL('Table'),MONTH('Table'[Date]) = _current_month))
VAR _previous_billing = CALCULATE(SELECTEDVALUE('Table'[Billing]),FILTER(ALL('Table'),MONTH('Table'[Date]) = _current_month - 1))
RETURN
_current_billing - _previous_billing
Result:
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, i tried replacing Billling with my table and it says syntax incorrect. I copied what you typed too and it says same?
Hi dommyw277
I have attached the PBIX file at the end of the reply, which you can download and open to check the difference with your own file.Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
