cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

use of "LEFT() or RIGHT()" type functions in Query Editor / Custom Column

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

1 ACCEPTED SOLUTION

Accepted Solutions
Super User I
Super User I

@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" 




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

1 REPLY 1
Super User I
Super User I

@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" 




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors