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.
Dear Community
I would like a M code to help me identify "(" in my string then extract the text before it
For example, I have the following function in Excel
=REDUCE(A2,CHAR(SEQUENCE(26,,65,1)),LAMBDA(x,Y,SUBSTITUTE(x,Y,"')))
With Power Query I would like the list of all the functions that were used to write it
My expected result should be, a list with the follwing records
REDUCE
CHAR
SEQUENCE
LAMBDA
SUBSTITUTE
Thanks for your time
Solved! Go to Solution.
You are a genius 🙂
Hi @mussaenda
I teste with a few formulas, it should work, any issues I'll let you know but for now I will mark this as resolved
Thanks for your assistance
Thanks @Vijay_A_Verma
However, I am not looking for the equivalent in PQ 😊
I would like the list of the functions used (obviously the final goal was not the function itself but rather an example)
Equivalent function in PQ is (Data is your column name here)
= Text.Combine(List.RemoveItems(Text.ToList([Data]),{"A".."Z"}))
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.