DurationDays between two dates and Today if end is blank

[Plukey]

I have two dates in power query Start & End Every column has a start date, but not every column has a finish date. I am trying to create a Custom column that has the number days of the record & if no end date use todays date Im unable to figure it out. Please help

 

[alansidman]

This assumes two columns Start and End
l

et
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Start", type date}, {"End", type date}}),
    #"Inserted Date Subtraction" = Table.AddColumn(#"Changed Type", "Subtraction", each if [End]= null then Duration.Days (Date.From(DateTime.LocalNow())- [Start]) else Duration.Days([End] - [Start]))
in
    #"Inserted Date Subtraction"

Book10
	A	B	C
1	Start	End	Subtraction
2	7/7/2020	8/1/2020	25
3	8/16/2021	9/1/2021	16
4	9/28/2020	10/5/2020	7
5	10/1/2021		52
6	9/18/2021		65
7	8/19/2021	9/1/2021	13
8	4/20/2021	5/1/2021	11
9	3/16/2021	5/1/2021	46
10	9/23/2021		60
11	5/24/2021	6/5/2021	12
Table1

 

[Plukey]

Fantastic!!! You saved the day! Thank you so very much!