nburaq
Board Regular
- Joined
- Apr 2, 2021
- Messages
- 222
- Office Version
- 365
- 2019
- Platform
- Windows
Hi,
I am working with office 2019 and I have datas based on year. In this data, there are years occured, event descriptions and finally lost hours.
As a rule, to call an event as a cause;
Code can be written in Power Query as a "M" code or in Power Pivot as DAX formula.
Thanks again for your help and comments!
I am working with office 2019 and I have datas based on year. In this data, there are years occured, event descriptions and finally lost hours.
As a rule, to call an event as a cause;
- Same event should happen 4 times or more in that year. In this case, total lost hours might be less than 8 hours
- Same event might happen less than 4 times in that year. In this case, total lost hours should be more than 8 hours
Code can be written in Power Query as a "M" code or in Power Pivot as DAX formula.
Thanks again for your help and comments!
Year | Event Description | Lost Hour | Is it accepted as Cause |
2022 | Pump A is broken | 1 | YES |
2022 | Pump A is broken | 1 | YES |
2022 | Pump B is broken | 4 | YES |
2022 | Pump B is broken | 4 | YES |
2022 | Pump A is broken | 2 | YES |
2022 | Pump A is broken | 1 | YES |
2020 | Heater C is broken | 1 | NO |