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)
Mahesh0016's avatar
Mahesh0016
Icon for Super User rankSuper User
3 years ago

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

  • Mahamood0218's avatar
    Mahamood0218
    Icon for Helper II rankHelper II
    3 years ago

    Mahesh0016 i got the result by using your formula.

    thank you.