Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have a dataset which requires Total count of incidents,Average of that count by date, and finally all the count by date >7.
I have used a few measures but am not sure how to create them.
I have attached the excel sheet for reference. The measures must give the below values.
The column values are :
https://github.com/Adityadambal/PowerBI/blob/4998f910458d080b71e971a24f7c9ba751287ceb/Book1.xlsx
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |