Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
44 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
73 | |
50 | |
45 | |
20 | |
17 |