Forum Discussion

dommyw277's avatar
dommyw277
Helper V
1 year ago
Solved

Month on Month Difference

Hi, I want to have a chart that shows me the difference month on month. I have a running total per month in the Billing field but even though i can see the monthly difference i would like a field t...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

Month01's avatar
Month01
New Member
1 year ago

Month name

 

Try this code

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