Forum Discussion
Need help
Hi everyone I need help with writing one or multiple dax formula to do the following My dataset looks like this : Operation Start date Start time End date End time 001 01/01/2022...
I forgot to mention. For days where there are transactions, if available time is less than 8h it will be considered 8h. otherwise it's the result of the calculation last transaction time - first transaction time
Ultimately I want to have a table as follows :
| Date | Usage | Available time | Usage % |
| 01/01/2022 | 2.25 | 8 | 28.25% |
| 02/01/2022 | 0.03 | 8 | 0.375% |
| 03/01/2022 | 0 | 8 | 0% |
| Total | 2.28 | 24 | 9.5% |
