Forum Discussion

DYY94's avatar
DYY94
Icon for Helper I rankHelper I
3 years ago

Subtract a date with number

Hello Comuunity,    I want to do this calculation  :  - For exemple:  [Maturite] - [MR/365] : 24/11/2025 - 3       Expected Output :        So i have created new table calle...
Need Help
Mahesh0016's avatar
Mahesh0016
Icon for Super User rankSuper User
3 years ago
Subtract a date = CALCULATE(MAX('Date'[Date]),DATEADD('Date'[Date],-2,YEAR))

Hello DYY94 ,
I hope above formula helpful for you ...... if it is useful for you kindly accept as solution mark .
 
thank you!
Mahesh0016's avatar
Mahesh0016
Icon for Super User rankSuper User
3 years ago

date interval "-2" replase with your column [MR/365].