Weekly running total difference 2023-2024

[SteffanieJ]

Hello!  Last year I had a running total measure that worked perfectly.  When I updated my data so my filter is set to 2025 it stopped working.  How do I update this formula to include filtering by year?

This is how it is looking now that I changed my filter to 2025.

This is the formula that is pulling in the data in the 2023 and 2024 columns. (just updated to -2 and -1 year).

OD SO 2023 = CALCULATE([SO Total Sales Shipped/Open],DATEADD('EB Orders'[SO CrtnDate].[Date],-2,year))

OD SO 2024 = CALCULATE([SO Total Sales Shipped/Open],DATEADD('EB Orders'[SO CrtnDate].[Date],-1,year))

It does work fine for my 2024-2025 comparison.

[v-fenling-msft]

Hi, @SteffanieJ 

May I ask if you have gotten this issue resolved? If it is solved, please share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

If it is not resolved, I hope you will provide the full .pbix file via OneDrive or SharePoint. Please be careful to remove all sensitive information and we will do our best to provide ideas for your issue.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SteffanieJ]

I did not,  I gave up and created new measures so I could leave the data the way it was before I changed the year.

[lbendlin]

what result do you expect?

[SteffanieJ]

I need the same numbers that are showing in the last column, YOY Week Diff Running Total column.

[lbendlin]

you seem to use a couple of nested measures. For troubleshooting you will want to run the raw calculation first  (it is also better for performance and maintainability). You can use EVALUATEANDLOG to see where the legacy logic breaks down.