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.
I am having issues with UNION of data and deleting columns. There other examples of this issue but I can't follow thier solutions. I can't suppy my actual data due to privacy reasons so I have made this example.
1. Here is a union of my data before I modify anything. Its just Namils thier colur and name.
The data with BADTEXT needs to be cleaned up. This seemed simple to me at the time.
In the query editor it seems simple. I just spit the colour data into 3 columns, delete the ones I dont need.
All I need to do is delete those new extra colurs and rename the column column I want to keep back to Colour
When I apply and refesh my data, that data I have been fixing now ends up in other columns.
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.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |