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.
My custom column is returning error based off a conditional column
Conditional Column
Code:
if [Triaging] = "Triaging" and [Triage Target] >= DateTimeZone.LocalNow() then "Triaging" else if [Triaging] = "Triaged" then "Triaged" else "Late"
This returns error for those in the triaging state
Triage Target is a custom column which is Start Date & Time & (04/24)
Any advise other than a replace Errors with Triaging?
Solved! Go to Solution.
Hi @ovde I have transformed the date format to match the left and it is fixed.
Thanks for your help.
hi @ovde
I have changed it DateTime.LocalNow() and I get this error
Expression.Error: We cannot apply operator < to types DateTime and Text.
Details:
Operator=<
Left=05/06/2023 11:15:50
Right=2023-06-02T14:40:00Z
Hi @ovde I have transformed the date format to match the left and it is fixed.
Thanks for your help.
Hi @MartynHead ,
Can you click on the error and tell us what is says? I suspect something is nog quite right with the DateTimeZone.LocalNow() function since your custom column is of the datetime type and not datetimezone. I suggest you use DateTime.LocalNow - PowerQuery M | Microsoft Learn
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |