topic Difference calculation between two date fields. in DAX Commands and Tips

Difference calculation between two date fields.

Anonymous — Wed, 21 Sep 2022 01:10:02 GMT

I am trying to calculate the datediff between Date1 and Date2 fields. Please note that Date2 column has values that are -1

If the date2 <0 , substitute the date2 value to today() before calculating "Difference" value.

Any help is appreciated.

amitchandak — Wed, 21 Sep 2022 02:14:29 GMT

Anonymous , I Power Query Replace them with Date.From(DateTime.FixedLocalNow()))

First replace -1 with null

then change datatype to date and then create a new column

if [Date2] = null then Date.From(DateTime.FixedLocalNow())) else [Date2]

Then you can use datediff in DAX

DAX

Datediff([Date1], [Date2], day)

Datediff([Date2], [Date1], day)