Forum Discussion

Mahamood0218's avatar
Mahamood0218
Helper II
3 years ago
Solved

Minus between the two dates

HI, I  need to do minus between two dates ex:  Clearing date1 - posting date1 = new date    could you please suggest dax formula.   Thanks.
Need Help
Show and Tell
Tips and Tricks
  • Mahesh0016's avatar
    Mahesh0016
    3 years ago
    new Date = DATEDIFF(MAX(XYZ[Clearing date1]),MAX(XYZ[ posting date1]),day)
goncalogeraldes's avatar
goncalogeraldes
Super User
3 years ago

Hi Mahamood0218! It looks like your date column is not formatted as a date so I would suggest a formula like the following:

 

Date_Diff = 
    DATEDIFF(
        DATEVALUE( SELECTEDVALUE( TableName[Posting Date1] ) ), -- can be MAX() instead
        DATEVALUE( SELECTEDVALUE( TableName[Clearing Date1] ) ), -- can be MAX() instead
        DAY -- type of interval for calculation
    )

 

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes