Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |