Forum Discussion
Avivek
Post Partisan
Post PartisanDax 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...
Greg_Deckler
Community Champion
Community ChampionAvivek - 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.