Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Hi,
This was quite fun dax to write. Here is an example on how to do this with a measure:
Data:
Dax:
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
Proud to be a Super User!
Hi @ValtteriN,
the solution is looking good, but i am not able to use your dax code flawless.
Do I need to create an extra Date table?
Hi,
Yeah, you would need a calendar table to make this work.
Proud to be a Super User!
Hello @ValtteriN,
thanks for your reply, i keep getting wrong numbers calculated.
So I rebuilt your tables and then it works fine. The problem is when there are more than one entries for one date, the numbers are getting calculated wrong. Can you help me with this problem?
User | Count |
---|---|
50 | |
23 | |
18 | |
18 | |
14 |
User | Count |
---|---|
91 | |
84 | |
39 | |
25 | |
21 |