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.

Kedar_Pande's avatar
Kedar_Pande
Super User
1 year ago

dommyw277 

Assuming you already have a measure for the running total, let's say it's called Running Total, you can create a new measure for the monthly difference like this:

Monthly Difference = 
VAR CurrentMonthTotal = [Running Total]
VAR PreviousMonthTotal = 
CALCULATE(
[Running Total],
PREVIOUSMONTH('Date'[Date]) 
)
RETURN
CurrentMonthTotal - PreviousMonthTotal

Drag the Month field from your date table to the Axis of the bar chart.
Drag the Monthly Difference measure you created to the Values section of the bar chart.

 

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

dommyw277's avatar
dommyw277
Helper V
1 year ago

Thanks. I dont have a running total measure, how do i add that first please?  

Its purely bars of costs per month with a total but just added up

  • Kedar_Pande's avatar
    Kedar_Pande
    Super User
    1 year ago

    Please share a simplified version of your PBIX file (in English) without sensitive data. You can upload it to a public cloud service like OneDrive, Google Drive, or Dropbox and share the link. This will help in understanding your data structure and the issue, allowing for more precise guidance.