Forum Discussion
monthly Case Count Incorrect for Rolling/YTD Totals
Title: Rolling 12-Month or YTD Case Count Is Correct Overall, But Monthly Breakdown Shows Wrong Values Hello everyone, I’m facing the following issue in Power BI/DAX and would appreciate your he...
Hi ThisIsBlecki,
May I ask if you have resolved this issue? If so, please mark the helpful reply and Accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank You.
Harshitha.
Community Support Team.
Hi Anonymous ,
Unfortunately, it didn’t work. Power BI applies a strange time filter that I can’t make sense of. Unfortunately, I can’t find a solution without Tabular Editor and DAX Studio.
I’ve moved the entire calculation logic to the data warehouse.
Thanks for your help, and sorry for the late reply — I was away.
Hi ThisIsBlecki ,
Thank you for confirming that the logic has been successfully moved to the data warehouse.
Regards,
Harshitha.