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
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
114 | |
73 | |
64 | |
51 | |
49 |
User | Count |
---|---|
184 | |
104 | |
82 | |
79 | |
78 |