Dates Column with two different columns

Question

Table Name: Projects&nbsp;ProjectID&nbsp; &nbsp;&nbsp; &nbsp;Active&nbsp; &nbsp;StartDate&nbsp; &nbsp;EndDate&nbsp; &nbsp;New Column&nbsp;1&nbsp; &nbsp;1&nbsp; &nbsp;1/1/2019&nbsp; &nbsp;1/3/2021&nbsp; &nbsp;1/3/20212&nbsp; &nbsp;1&nbsp; &nbsp;5/5/2019&nbsp; &nbsp;(Blank)&nbsp; &nbsp;5/5/20203&nbsp; &nbsp;1&nbsp; &nbsp;3/7/2020&nbsp; &nbsp;3/9/2021&nbsp; &nbsp;3/9/20214&nbsp; &nbsp;1&nbsp; &nbsp;1/7/2020&nbsp; &nbsp;(Blank)&nbsp; &nbsp;1/7/20215&nbsp; &nbsp;1&nbsp; &nbsp;2/9/2020&nbsp; &nbsp;(Blank)&nbsp; &nbsp;2/9/20216&nbsp; &nbsp;1&nbsp; &nbsp;10/9/2020&nbsp; &nbsp;5/1/2021&nbsp; &nbsp;5/1/20217&nbsp; &nbsp;1&nbsp; &nbsp;11/11/2020&nbsp; &nbsp;6/6/2021&nbsp; &nbsp;6/6/20218&nbsp; &nbsp;0&nbsp; &nbsp;12/01/2021&nbsp; &nbsp;(Blank)&nbsp; &nbsp;(Blank)9&nbsp; &nbsp;0&nbsp; &nbsp;7/6/2021&nbsp; &nbsp;(Blank)&nbsp; &nbsp;(Blank)&nbsp;It's my data, I'm looking for a solution to this situation.&nbsp;&nbsp;If my Projects[End Date] is Blank so I will take the column Projects[Start Date] + 365 days only if Projects[Active] = 1 if is Projects[End Date] with the date so I will keep these dates in the&nbsp;new column.

ba_pete · Accepted Answer

Hi&nbsp;dolevh&nbsp;,
&nbsp;
Try this in a custom column:
if [EndDate] = null and [Active] = 1 then Date.AddDays([StartDate], 365)
else [EndDate]
&nbsp;
Pete

Forum Discussion

Dates Column with two different columns

2 Replies

Related content

New Column

Grouping rows by Column and then updating Column

Create a Column where sum two columns from different tables

Different Groupby Column Names in Summarize

Unpivot Column

ProjectID	Active	StartDate	EndDate	New Column
1	1	1/1/2019	1/3/2021	1/3/2021
2	1	5/5/2019	(Blank)	5/5/2020
3	1	3/7/2020	3/9/2021	3/9/2021
4	1	1/7/2020	(Blank)	1/7/2021
5	1	2/9/2020	(Blank)	2/9/2021
6	1	10/9/2020	5/1/2021	5/1/2021
7	1	11/11/2020	6/6/2021	6/6/2021
8	0	12/01/2021	(Blank)	(Blank)
9	0	7/6/2021	(Blank)	(Blank)