Cumulative sales runs too far out

[mra1984]

media_cost_£ YTD =

IF(

    ISFILTERED('Calendar'[Date]),

    ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),

    TOTALYTD(SUM('ALLCHANNELS'[media_cost_£]), 'Calendar'[Date].[Date])

)

this works but runs till end of Dec 2020?  How to get it to only go till today? Thanks

[Greg_Deckler · Accepted solution]

@mra1984 - You can create an IF statement where if the max date is > TODAY, return BLANK, otherwise return the calculation

[amitchandak]

@mra1984 , Try like these example

YTD QTY forced= 
var _max = maxx('order',[Order date])
return
calculate(Sum('order'[Qty]),DATESYTD('Date'[Date]),'Date'[Date]<=_max)
//calculate(TOTALYTD(Sum('order'[Qty]),'Date'[Date]),filter('Date','Date'[Date]<=_max))

LYTD QTY forced= 
var _max1 =maxx('order',[Order date])
var _max = date(year(_max1)-1,month(_max1),day(_max1))
return
CALCULATE(Sum('order'[Qty]),DATESYTD(dateadd('Date'[Date],-1,year)),'Date'[Date]<=_max)
//TOTALYTD(Sum('order'[Qty]),dateadd('Date'[Date],-1,year),'Date'[Date]<=_max)