DateDiff not working the same in excel as it is Powerbi

[jak828]

Hi,

In PowerBI I have a measure with

DaysPastDueDate = DATEDIFF (AUDIT_HEADER[DUE_DATE], TODAY (),DAY)

That doesnt seem to work in Excel PowerPivot and it requires it to be a calculated column.

If I make the column witrh that calculation it doesnt seem to like it when the start date is greater than the end date.. in Powerbi this gives negative numbers however in Excel it causes it to break.

Any idea how to get round this when the start date is greater?

Thanks

Chris

 

[jak828]

I have also tried

=IF(AUDIT_HEADER[DUE_DATE]>today(),-DATEDIFF (AUDIT_HEADER[DUE_DATE], TODAY (),DAY),DATEDIFF (AUDIT_HEADER[DUE_DATE], TODAY (),DAY))

to no avail.