Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I'm trying to add a column in the query editor by using an if-then statement based on the left x characters of one of the other columns in my table. When I use a nested if statement in the table itself and add the custom field, this seems to work using yet this does not seem to work when adding a custom column in the query editor environment. Here's what I've tried:
if left(column,5)="abcde" then "a" else "b"
I realise I could work with adding the column outside the query editor, but I'd like to understand how to use the function inside it as well.
thanks
Solved! Go to Solution.
@Anonymous Functions in DAX and M-Language (Power Query) are different.
You need to use as below in Power Query Editor as custom column
if Text.Start(column,5) = "abcde" then "a" else "b"
if Text.End(column,2) = "de" then "d" else "e"
Proud to be a PBI Community Champion
@Anonymous Functions in DAX and M-Language (Power Query) are different.
You need to use as below in Power Query Editor as custom column
if Text.Start(column,5) = "abcde" then "a" else "b"
if Text.End(column,2) = "de" then "d" else "e"
Proud to be a PBI Community Champion
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |