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!
DYY94's avatar
DYY94
Icon for Helper I rankHelper I
3 years ago

Hi Mahesh0016 , 

 

Thanks for your help. 

 

I just used your code. it's not the output i wanted. it gave me always the same date or it should gave me the other dates. 

 

This is the output with your code : 

Expected output : 

 

 

 

 

Thanks.