Forum Discussion

Avivek's avatar
Avivek
Icon for Post Partisan rankPost Partisan
6 years ago

Dax measure needed for day diff

I want to calculate the days difference between the payment received date and invoice date and the calculated column i used is Days Diff = (RECEIVABLES[Payment Recieved date])-(RECEIVABLES[Invoi...
DAX
DAX Calculation
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Avivek ,

 

Use this measure for calculating difference between days.

 

Days Diff =
DATEDIFF (
    MAX ( RECEIVABLES[Payment Recieved date] ),
    MAX ( RECEIVABLES[Invoice Date] ),
    DAY
)

 

https://dax.guide/datediff/

 

Regards,
Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!