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,
Thanks for seeing this Question.
I'm trying to find a solution to split column in to rows based on the Value in the Column.
In my scenario the text that determines the split is 'New'. if the Column has this text then it should be split in to seperate row and keeping other values/text in Tact.
This is the Source Data
I would like to see the Outputs as Below
I did try to include the if condition and there are errors.
Can anyone help me out please.
Regards
Solved! Go to Solution.
Hi,
In Power Query I did copy twice from particular Table :
1- in the first one,
A- I add Custom Column and use below M code : if Text.Contains([Desc], "New") then "New" else ""
B- Filter the new Column just for the rows including 'New'
C- Remove the Desc Column and rename the new column to Desc
2- In the second one,
A- I Replace the New with Space for Desc Column
B- Replace ", ," with ","
C- Trim the Desc Column
D- RightTrim the "," from the end
3- Now if Append these two ones together, the new table is included the particular rows :
Appreciate your Kudos
thank you all
Hi,
In Power Query I did copy twice from particular Table :
1- in the first one,
A- I add Custom Column and use below M code : if Text.Contains([Desc], "New") then "New" else ""
B- Filter the new Column just for the rows including 'New'
C- Remove the Desc Column and rename the new column to Desc
2- In the second one,
A- I Replace the New with Space for Desc Column
B- Replace ", ," with ","
C- Trim the Desc Column
D- RightTrim the "," from the end
3- Now if Append these two ones together, the new table is included the particular rows :
Appreciate your Kudos
Hi @karthik69 ,
Please find the below link for your reference.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Thanks,
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
84 | |
84 | |
66 | |
63 | |
62 |
User | Count |
---|---|
199 | |
120 | |
110 | |
79 | |
69 |