Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
Here we have a data on the Column "A". we need to eliminate the text "Excess" and paste other data into Column "B".
Thanks..!
Please look at this @Ahmedx. Thanks..!
Solved! Go to Solution.
Hello @Ahmedx ,
Thanks for your reply.
Could you please provide the format in the power Query Editor. Because it show some errors with what I type with you gave it.!
Thanks.!
yes, I already wrote how to do this in power query
Try this:
IF( SELECTEDVALUE( columnA) = "EXCESS", BLANK(), SELECTEDVALUE( columnA) )
Proud to be a Super User!
Hello _AAndrade,
Thanks for your reply.
Could you please send it in the query editor format.
Thanks.!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
179 | |
108 | |
104 | |
71 | |
70 |