Forum Discussion
difference between data _ months in same column
Hi Cynthia. In order for this to work, you need to do three things first:
- Make sure your data model has a date table and that it is marked as one
- Convert your values of "Jan 21", "oct 21", etc. to actual date values. Go with month ending values.
- Create a relationship between the date field in the date table and the date field in your data.
After you do those things, create measures like the following
Current Month = SUM([Value]) Prior Month = CALCULATE( [Current Month] PREVIOUSMONTH([Use the name of the date column from the date table]) ) MTM Difference = [Current Month] - [Prior Month]Hope this helps!
Hi Cynthia
I created the solution for you. Follow the logic in the attached pbix. Let me know if you have any questions. 🙂
Hi littlemojopuppy ,
firstly, thank you very much for your support and apologies for my late response. I work on it on weekends.
I have tried to apply your suggestion but without success. I will still try to find the error I am probably doing when following the reasoning. I have just started. I will give you a more assertive response if I find the mistake when replacing the data.
Thank you very much.
Kind regards,
Cinthia
Hi Cynthia
I created the solution for you. Follow the logic in the attached pbix. Let me know if you have any questions. 🙂