Nested IF - Power Query

[RMRaptor]

Hello All

How can i traslate this excel expression to power query calculated column.

If Startdate is before TaskStartDate then Plan TaskStartDate
else if Start date is between Taskstartdate and TaskEnddate then startdate
else if start date is after TaskEndDate else null

RP

[ray_aramburo · Accepted solution]

Add a Custom Column within Power Query and then write:

if [startdate] is null then null else 

if [startdate] < [TaskStartDate] then [Plan TaskStartDate] else if

[startdate] >= [TaskStartDate] and if [startdate] <= [TaskEnddate] then [startdate] else if [start date] > [TaskEndDate] then [whatevercolumnorconditionyouneed] else null

I purposefully started with an evaluation of the startdate being null, because if you have null values in that column, you'll get an error after creating the column.