Forum Discussion

Mahamood0218's avatar
Mahamood0218
Icon for Helper II rankHelper 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)

5 Replies

  • Mahesh0016's avatar
    Mahesh0016
    Icon for Super User rankSuper User
    3 years ago
    new Date = DATEDIFF(MAX(XYZ[Clearing date1]),MAX(XYZ[ posting date1]),day)
  • goncalogeraldes's avatar
    goncalogeraldes
    Icon for Super User rankSuper 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

  • Mahesh0016's avatar
    Mahesh0016
    Icon for Super User rankSuper User
    3 years ago

    can you please write the expected RESULT after subtracting two dates.