Forum Discussion

admin_xlsior's avatar
admin_xlsior
Post Prodigy
5 years ago
Solved

How to hide date in SAMEPERIODLASTYEAR function

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,

 

 

 

Tips and Tricks
  • amitchandak's avatar
    amitchandak
    5 years ago

    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))

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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))