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[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.

DAX
DAX Calculation

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago

    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.

  • 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!