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

Custom Function in Query

I Can do this task using modelling and DAX.

 

But i want it using "invoke Custom Functions".

 

Requirement is i have key column as below

 

Key

Id-1

Id-10

Id-100

 

So i want to display only number and remove "ID-" from column

 

Thanks,

Pravin

1 ACCEPTED SOLUTION
Anonymous
Not applicable

M-function that takes a table and returns a table.PNG

It works for me. You have to create a function in Power Query and then change its body accordingly.

 

Best

D

View solution in original post

40 REPLIES 40

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.