I need to get the TotalYTD function to only give cumulative totals thru yesterday. So if today is 4/17.23 I want to see the cumaltive total thru 4/16/23. On the next day it would go up 1 and so on.
I have successfully written the DAX to give me a cumulative total how to I get it to stop on yesterday? Itried the TODAY() function but something isn't right.
As a measure, I used
Go to Solution.
View solution in original post
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.