Forum Discussion

Sannaka's avatar
Sannaka
New Member
4 years ago
Solved

Calendar -table, date x months before today

I want to create a new column to my Calendar table that shows the date four months before today. This is the formula I've used: 4 months history = DATE( YEAR( Calendar[Date] ), MONTH( Calendar[Date...
Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    HI Sannaka ,

     

    You can try below code:-

    4 months history =
DATEADD ( Calendar[Date], -4, MONTH )

    Thanks,

    Samarth

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

HI Sannaka ,

 

You can try below code:-

4 months history =
DATEADD ( Calendar[Date], -4, MONTH )

Thanks,

Samarth