Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Del235
Helper III
Helper III

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])
1 ACCEPTED SOLUTION
Ajendra
Resolver I
Resolver I

Hi @Del235

 

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

 

View solution in original post

3 REPLIES 3
Ajendra
Resolver I
Resolver I

Hi @Del235

 

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

 

FreemanZ
Super User
Super User

or like:

Measure = 
CALCULATE(
    SUM(Table1[Attendance]),
    Table1[Visit Date]>=DATE(YEAR(TODAY()), 1, 1),
    Table1[Visit Date]<TODAY()
)
FreemanZ
Super User
Super User

hi @Del235 

try like:

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

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.