Forum Discussion
Solved
Summarize Names from multiple Columns
Hi Experts. I have one table: Project Discipline 1 Discipline 4 Discipline 5 Discipline 6 Prj1 Mike Carlos Michael Prj2 Charlie Carlos Max Prj3 x Matheus Charli...
FelipeDelamar , Please find the attached file if that can help
FelipeDelamar , Unpivot the data in power Query
https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/
Then you can create summarize with count or
And create a Pivot in visual using matrix and count
Hey amitchandak
As i follow your steps (unpivot and transpose).
I think it isn't right, how can i summarize with the data like this?
FelipeDelamar , Please find the attached file if that can help
Great! Thank u, it was much more easy them I expected 😅
