Calculate UsageTime per Day
Hello, I'm new to Power BI and need your help: I have a table with licenese and now I want to calculate their Utilization per Day. There are 2 licenses(BIE-WV414 and BIE-WV450) with licenseStart time and licenseEnd time, per day there are many licenses started and finsihed. I also have calculated the usagetime (in total). The problem is some of the licenses are used longer than 24 hours or past midnight. (See Screenshot). Now i want to calculate and display the usage time of each license per day. For example for the first line: 1.10 BIE-WV414 aprox. 22h 2.10 BIE-WV414 24h 3.10 BIE-WV414 aprox. 7min Regards, Jani
