cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FilippoV Regular Visitor
Regular Visitor

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

1 REPLY 1
BeemsC Member
Member

Re: DAX Formula Date

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