Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
Proud to be a Super User!
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.
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
106 | |
87 | |
74 | |
66 |
User | Count |
---|---|
125 | |
114 | |
98 | |
81 | |
73 |