Forum Discussion

Del235's avatar
Del235
Icon for Helper III rankHelper III
3 years ago
Solved

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....
TOTALYTD
Yesterday
  • Ajendra's avatar
    Ajendra
    3 years ago

    Hi Del235

     

    Query = TOTALYTD([Total Sale],
    DateMaster[Date],
    DateMaster[Date]<TODAY())
     
    Check below Screen Shot of Output.

     

Ajendra's avatar
Ajendra
Icon for Resolver I rankResolver I
3 years ago

Hi Del235

 

Query = TOTALYTD([Total Sale],
DateMaster[Date],
DateMaster[Date]<TODAY())
 
Check below Screen Shot of Output.