Difference calculation between two date fields.

[Anonymous]

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. 

Date 1	Date 2	Difference
8/1/2019	1/1/2022
9/1/2019	2/1/2022
10/1/2019	3/1/2022
11/1/2019	4/1/2022
12/1/2019	5/1/2022
1/1/2020	6/1/2022
2/1/2020	7/1/2022
3/1/2020	8/1/2022
4/1/2020	-1
5/1/2020	-1

[amitchandak · Accepted solution]

@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)

or

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