Forum Discussion

belurrashmi's avatar
belurrashmi
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...
Need Help
  • vanessafvg's avatar
    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.

     

     

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi belurrashmi,

 

Assume you want to count distinct Creator columns based on Year and Month values, you can use Group By in Query Editor. Also you can use DAX to create a calculated table like below:

 

Table = SUMMARIZE('Table1','Table1'[Year],'Table1'[Month],"No.unicusers",DISTINCTCOUNT('Table1'[Creator]))

 

 

Best Regards,
Qiuyun Yu