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 have a set of data that looks like this example (although th real one has >600 "log work" columns, each of which has a name, date and time which I intend to extract after I figure this part out)
I need to be able to compare each "log work" entry with others from the same assignee, and my thoughts were to append the columns onto each other in a new table somehow like so (this is just imported from a manually created excel sheet):
I managed to get several of the columns appended to each other in a new table using DAX but that required manually typing out each column name, and in the real data set I have over 600 (which could change to be more or less depending on the database users) so I'm not really sure if typing out a few thousand lines of code just to create a table that just won't take in data from the database after a certain number of columns is worth it. If anyone has an idea of how I could go about either looping my dax code through multiple columns based on their names, or if anyone just has an alternative way of comparing the things I need to that would be really helpful.
Solved! Go to Solution.
Hi, @JoshHall
According to your description, I think you can get the expected data through the Power Query editor, you can follow my steps:
And you can get what you want, like this:
You can download my test pbix file here
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @JoshHall
According to your description, I think you can get the expected data through the Power Query editor, you can follow my steps:
And you can get what you want, like this:
You can download my test pbix file here
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@JoshHall , based on what I got Unpivot
https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/
Use Power Query. select the 1st column. Unpivot 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 |
---|---|
104 | |
96 | |
79 | |
67 | |
62 |
User | Count |
---|---|
137 | |
106 | |
104 | |
81 | |
63 |