Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Need help aggregating and filtering the underlying data by date.
Peter, James and John perform actions (they read books and/or papers) on dates January 1 to January 9.
Date | Action | Person |
jan 1 | Book | Peter |
jan 2 | Paper | James |
jan 2 | Book | John |
jan 4 | Book | Peter |
jan 4 | Book | Peter |
jan 5 | Paper | James |
jan 6 | Book | James |
jan 7 | Paper | John |
jan 8 | Book | Peter |
jan 9 | Paper | Peter |
I want to aggregate this data by Action to show how many times a certain action was performed by somebody during a given date interval. And I must be able to filter dates. If we take the data over all dates we get:
1 | 2 | >=3 | |
Book | 2 | 1 | |
Paper | 2 | 1 |
This shows that in the full time interval 2 persons read a book ONE time (James and John), and 1 person read a book AT LEAST THREE times (Peter, he did it 4 times).
Also, 2 persons read a paper ONE time and 1 person read a paper TWICE.
If we take January 2-6 we get this:
1 | 2 | >=3 | |
Book | 2 | 1 | |
Paper | 1 |
Here we see that again 2 persons read ONE book and 1 person read TWO.
And 1 person read the paper TWICE.
So, I need to aggregate like this, filter by date and show number of events like 1, 2, and >=3.
Ideas?
@DrH , I think you need Dynamic Segmentation Bucketing Binning on count measure, refer example
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k
Thanks for the attempt, but nope, that is not what I am looking for.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
21 | |
20 | |
15 | |
13 |
User | Count |
---|---|
45 | |
41 | |
39 | |
19 | |
19 |