Forum Discussion
Solved
How to group data from multiple columns from single table?
I have a table of this kind Defect ID Created Creator Assignee Resolved 1 01/05/2017 A B C 2 01/06/2017 B B 3 01/07/2017 A C C 4 01/08/2017 A C C 5 01/09/20...
i would unpivot the three colums (creator asignee and resolved in power query)
and then do a distinctcount in a measure on them sliced by the date.
i would unpivot the three colums (creator asignee and resolved in power query)
and then do a distinctcount in a measure on them sliced by the date.