Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi Power BI community,
I am trying to count the number for events that different fixtures have over the life of the fixture as measured by date and number of hits on the fixture. When the fixture is worn out, it is repaired and the number of hits resets. I am currently using this function below to calcaulte the running count for each die. It works until the die hits is reset, and then it does not calculate the count as I would like.
Event | Die | Date | Die Hits | Event Count (Current) | Event Count (Ideal) |
A | X | 8/1/24 | 205 | 1 | 1 |
A | X | 8/2/24 | 300 | 2 | 2 |
A | X | 8/3/24 | 330 | 3 | 3 |
B | Y | 8/3/24 | 1400 | 1 | 1 |
B | Y | 8/4/24 | 1456 | 2 | 2 |
A | X | 8/5/24 | 500 | 4 | 4 |
B | X | 8/6/24 | 210 | 2 | 1 |
A | X | 8/6/24 | 240 | 3 | 2 |
A | X | 8/7/24 | 310 | 3 | 3 |
My second part to this question, is how would I go about displaying just information from the most recent reset for each fixture in report view. Ultimately, I want to display this information in a graph similar to the one below.
First part - DAX does not support conditional accumulations. The only tool I know of that can do that is Power Query's List.Accumulate.
Second part is actually easier. You can use a measure to identify the last reset point and then suppress everything before that point.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
24 | |
14 | |
12 | |
12 | |
8 |
User | Count |
---|---|
31 | |
27 | |
16 | |
13 | |
12 |