harishrathore: April 13, 2023, 4:12pm
Hey folks,
I need some quick help over here. How can I calculate the volume for the previous three months with DAX? So let’s say we’re in March, I need the volume for the last three months (January to March). I’ve been using this DAX formula:
CALCULATE (
[Volume],
DATESINPERIOD ( ‘Calendar’[Date], LASTDATE ( ‘Calendar’[Date] ), -3, MONTH )
)But now, I only want to select March, but get the volume for the last three months (October to December). Can anyone help me crunch these numbers? Basically, I need a 3-month-over-3-month volume comparison. Appreciate it!
Best,
Harish Rathore
Harsh: April 14, 2023, 1:41am
Hey @harishrathore,
Thanks for reaching out. To get what you’re asking for, you’ll need to add another Date table to your data model and create an inactive relationship with the original Date table. Here’s a visual of the data model I’m talking about:
Data Model picture
Now, create a measure for the “Total Sales Last 3 Months” and then, create a measure for “Total Sales for Previous Last 3 Months”. Finally, fix the totals of the “Total Sales for Previous Last 3 Months” with another small measure.
Here’s how the final results should look:
Final Results picture
I’m also attaching a PBIX file so you can see it all in action. Hope this helps!
Best,
Harsh
EnterpriseDNA: April 17, 2023, 8:38pm
Great job, @harsh. Thanks for stepping up with a solution.
Hey @harishrathore, did that answer your question? Remember to mark this thread as ‘solved’ if it did!
adesinamk: April 18, 2023, 8:47pm
Hello @harishrathore,
Thanks for bringing up this question.
And @Harsh,
Thanks for the detailed answer. I’ll be giving this a try since I had a similar question. Thanks again!
EnterpriseDNA: April 20, 2023, 11:31pm
I hope the responses above answered your question, @harishrathore. Remember, if your question has been answered, mark this thread as ‘solved’. If there’s no more activity on this post in the next few days, we’ll tag it as Solved.
harishrathore: April 25, 2023, 6:14am
Thanks a ton @Harsh for the solution. Kudos to you…
Best,
Harish Rathore
