Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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/2016 | F | G | H |
6 | 01/10/2016 | A | B | C |
7 | 01/11/2016 | A | A | F |
8 | 01/12/2017 | A | F | G |
9 | 01/13/2017 | A | F | G
|
I would like to combine all the Users data and see the information in this way
Created in month | No.of unique users |
May-2017 | 2 |
Jun-2016 | 3 |
May-2016 | 4 |
Solved! Go to Solution.
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.
Proud to be a Super User!
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
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?
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.
Proud to be a Super User!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
56 | |
55 | |
54 | |
37 | |
29 |
User | Count |
---|---|
77 | |
62 | |
45 | |
40 | |
40 |