Forum Discussion

reynaldo_malave's avatar
reynaldo_malave
Icon for Helper III rankHelper III
5 years ago
Solved

Equivalent Date

Hi Guys,   I am trying to create a column on my calendar with an equivalent date from last year. For example Today June 17th 2021 is the 3rd thursday my equivalent date would be the third thursday ...
  • amitchandak's avatar
    amitchandak
    5 years ago

    reynaldo_malave ,  Last year same week is 364 days behind

    [Date]  -364

     

    364 behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-364,DAy))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

reynaldo_malave ,  Last year same week is 364 days behind

[Date]  -364

 

364 behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-364,DAy))