Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
PattemManohar
Community Champion
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" 




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

Proud to be a PBI Community Champion




View solution in original post

1 REPLY 1
PattemManohar
Community Champion
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" 




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

Proud to be a PBI Community Champion




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.