How to hide date in SAMEPERIODLASTYEAR function

[admin_xlsior]

Hi,

So I have this sales amount for this year, as simple as like this:

Sales Amt = SUM(Sales(amount))

And then I have this Previous year like this:

Sales Amt PY = CALCULATE([Sales Amt], SAMEPERIODLASTYEAR(Dates[date]))

As today is just until April and obvously no sales for future, however for Previous year have. Question is how to hide those Previous year of May - Dec 2020 ? because currently my chart has those and I want to hide it.

Thanks,

[amitchandak · Accepted solution]

@admin_xlsior , Try like

YTD QTY forced=
var _max = today()
return
if(max('Date'[Date])<=_max, CALCULATE([Sales Amt], SAMEPERIODLASTYEAR(Dates[date])), blank())

or

YTD QTY forced=
var _max = today()
return

calculate([Sales Amt], SAMEPERIODLASTYEAR(Dates[date]),filter('Date','Date'[Date]<=_max))

or

Year behind Sales = CALCULATE([Sales Amt],dateadd('Date'[Date],-1,Year))