Forum Discussion

cwnoll's avatar
cwnoll
Frequent Visitor
6 years ago

help with getting total between two dates

I am having issues getting the right dax measure to find the cummulative total between two dates in the past. the tricky part is i need to go back a 6mth period and then get the total of the previous...
DAX Calculation
Help with DAX Measure
cwnoll's avatar
cwnoll
Frequent Visitor
6 years ago

Thank you so much for the quick feedback, but this still didnt work. Maybe I can attempt to explain better. 

My current month is April 2020, I need to find the SUM of the gross charges for May 2019 thru Oct 2019. The idea is April 2020 would skip previous 6 months, then get the sum of the previous 6 months to that.

 

Since current Month is April 2020, it would skip Mar2020,Feb2020,Jan2020,Dec2019,Nov2019,Sep2019, then sum Oct2019-May2019.

 

Does this help at all?

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

What result did you see with my latest expression?  I was pretty sure that would do it.  Are you using the Month column from your Calendar table in your visual?  Can you say more about your model?

 

If this works for you, please mark it as solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat