Dax measure needed for day diff

[Avivek]

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[Invoice Date])
It is a straight forward measure but it seems to not work in all cases

S.No 5 if you see the difference in the date is 28 days but it shows 56, similarly S.No 5 the difference is 49 days.

Is there any update I need to do for the measure.

[harshnathani]

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!

[Greg_Deckler]

@Avivek - Try:

Days Diff = ((RECEIVABLES[Payment Recieved date])-(RECEIVABLES[Invoice Date])) * 1.

Otherwise, confirm there is not a duplicate record. 28 + 28 = 56 so it is suspicious. You are probably using a default SUM aggregation on that column.