Forum Discussion

Frequent Visitor

9 years ago

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...

vanessafvg
9 years ago
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.

Icon for Community Champion rank

Community Champion

9 years ago

That is some magic transformation.

Apparently all dates are in January (because of 01/13/2017 in the last row) and it results in data in May and June.

Also in your table there are no "users".

Of course we can assume that Creators, Assignees and Resolved are users, but one of the first things I was taught in IT is to assume nothing.

Can you explain the logic how your source data is transformed into the result?