The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
On specific rows of my data set, I would like to move a row of text after a specific column to a new row down.
Much like a carriage return would do. My power query creativity is very low today.
Thank you...
For example:
Would like to move the data after the arrow to a new row.
RAW data csv. From this....
...to this in Power Query (new row)
Stuck here.
Hi, i'm sure that exist another way but i will do thiw:
Duplicate the Query
Filter Rows that contain max_eyew in Column 9
Remove other Columns (1 to 😎
Rename the column names (1 to 😎
Append to Original Query
Regards
Victor
That trick row occurs in multiple places in the data set.
If it happened only once, your solution would work, but
that trick row happens 16 separate times.
...
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
78 | |
66 | |
52 | |
50 |
User | Count |
---|---|
121 | |
120 | |
78 | |
63 | |
62 |