Forum Discussion
Weekly running total difference 2023-2024
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).
5 Replies
- lbendlin
Super User
what result do you expect?
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.
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.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.
