Hi All,
I've 200+ rows of data that will have a call history for the past 6 months and I would like to merge the distinct users along with need add to the call minutes parallely for each distinct user and need to make a separate table from it.
Any help on this would be much appreciated.
Thank you!
You can create a new rable using the SUMMARIZE() DAX function as per the document in the link:
https://learn.microsoft.com/en-us/dax/summarize-function-dax
User | Count |
---|---|
142 | |
63 | |
61 | |
59 | |
48 |
User | Count |
---|---|
138 | |
68 | |
63 | |
63 | |
56 |