Minus between the two dates

[Mahamood0218]

HI,

I  need to do minus between two dates

ex:  Clearing date1 - posting date1 = new date 

could you please suggest dax formula.

Thanks.

[Mahesh0016]

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

[Mahamood0218]

@Mahesh0016 i got the result by using your formula.

thank you.

[Mahesh0016 · Accepted solution]

new Date = DATEDIFF(MAX(XYZ[Clearing date1]),MAX(XYZ[ posting date1]),day)

[Mahamood0218]

@Mahesh0016 i want new date means , if we substract two dates we will get new date?

[goncalogeraldes]

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