Grand Total thru Today()

[Del235]

What would be the syntax for a grand total thru Today?  I'm using a date table where I'm using the field Date

[Poojara_D12]

Hi @Del235 

Total Through Today =
CALCULATE(
SUM(Sales[SalesAmount]), 
'Date'[Date] <= TODAY() 
)

[Del235]

I thought the TOTALYTD would only total for the current year?

[danextian · Accepted solution]

Hi @Del235 

TOTALYTD creates YTD value for the year in the current context. It will continue to calculate up to the last date in your dates table.

If you want to calculate the YTD value up to today's date equivalent in the past years, try this:

YTD up to today = 
VAR _Today =
    TODAY ()
VAR _EndDate =
    DATE ( MAX ( Dates[Year] ), MONTH ( _Today ), DAY ( _Today ) )
VAR _YrMonthToday =
    FORMAT ( TODAY (), "mmdd" )
VAR _Result =
    CALCULATE (
        SUM ( 'DataTable'[Value] ),
        FILTER (
            ALL ( Dates ),
            Dates[Year] = MAX ( Dates[Year] )
                && Dates[Date] <= MAX ( Dates[Date] )
                && Dates[Date] <= _EndDate
        )
    )
RETURN
    _Result

[Gabry]

Measure = TOTALYTD(sum('yourtable'[yourvalue]), 'datetable'[date])