yesterday
1 Topic
Getting TOTALYTD thru yesterday
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 Measure = TOTALYTD(SUM(Table1[Attendance]),Table1[Visit Date])Solved2KViews0likes3Comments