topic Re: Getting TOTALYTD thru yesterday in DAX Commands and Tips

Getting TOTALYTD thru yesterday

Del235 — Mon, 17 Apr 2023 20:33:33 GMT

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])

Re: Getting TOTALYTD thru yesterday

FreemanZ — Mon, 17 Apr 2023 21:51:09 GMT

hi Del235

try like:

Measure = TOTALYTD(SUM(Table1[Attendance]),Table1[Visit Date])

CALCULATE(SUM(Table1[Attendance]),Table1[Visit Date]=TODAY()-1)

Re: Getting TOTALYTD thru yesterday

FreemanZ — Mon, 17 Apr 2023 21:56:26 GMT

or like:

Measure =

CALCULATE(

SUM(Table1[Attendance]),

Table1[Visit Date]>=DATE(YEAR(TODAY()), 1, 1),

Table1[Visit Date]<TODAY()

)

Re: Getting TOTALYTD thru yesterday

Ajendra — Mon, 17 Apr 2023 22:12:18 GMT

Hi Del235

Query = TOTALYTD([Total Sale],

DateMaster[Date],

DateMaster[Date]<TODAY())

Check below Screen Shot of Output.