Forum Discussion

FilippoV's avatar
FilippoV
Helper I
8 years ago

DAX Formula Date

Hi Community,
i'm fighting to fina a way to get a dinammicaly dax calculation. I want calculate dinammically:
TODAY (ok, easy) --> 23/11/2017 Thursday
SAME DAY OF PREVIOUS YEAR (SAME WEEK) --> 24/11/2016 Thursday
YTD OF PREVIOUS YEAR --> 23/11/2016

The calculations are base on Today (Today()).
Any help?

Thanks in advanced

Need Help
Tips and Tricks

1 Reply

  • BeemsC's avatar
    BeemsC
    Resolver III
    8 years ago

    I don't exactly understand what you mean.
    But probably the function you are looking for is SAMEPERIODLASTYEAR()