Forum Discussion

Miska's avatar
Miska
Icon for Helper I rankHelper I
4 years ago
Solved

Getting Previous Year values for Selected month in SLicer

Hi Experts!   I have a report wherein I need to Display a KPI card for Current Year Sales amount based on the Year selected which is  single selecte and Month Selection which is a multi Select filt...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    4 years ago

    DATEADD works with any Date Table selection:

     

    But you do need a proper date table with unique, continuous date values

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
4 years ago

Try:

Previous year values =
CALCULATE([Your measure], DATEADD(Date Table [Date], -1, YEAR))

Miska's avatar
Miska
Icon for Helper I rankHelper I
4 years ago

I have already tried that but the issue here is that the DATEADD needs a continous selection of months in the slicer , cannot do random months  for the calculation.

  • PaulDBrown's avatar
    PaulDBrown
    Icon for Community Champion rankCommunity Champion
    4 years ago

    DATEADD works with any Date Table selection:

     

    But you do need a proper date table with unique, continuous date values