Resource Usage

[jb_graphic]

I am looking for some direction.

I do not even know what to search for so I can learn how to do.

I want to have a Resource usage visual that will show how much usage a resource has at any given time.

The part I am struggling with is how do I shape the data so that when a single process last for multiple days I can split it up to show say 100% usage for the full days and then say the remainder on the following days.

I.e say I have a process that runs non stop for 29 hrs how would I show that in a visual so that the visual is not more than 100% for a day?

Links to information would be great.

Thanks

[christinepayton]

Use a DAX measure and a variable in the DAX measure to calculate the usage. Then, for the return, use an if-statement, something like RETURN IF(resourceusage > 1, 1, resourceusage). Format it as a percentage with measure settings.

This return will return 100% if the calculation is over 100%, if not it will return the actual value. 

[jb_graphic]

I am not sure if this is what I am looking for. But will try.

Say I have a process that last 2.5 days from start to finish.
I want the output to be

Day 1 say 80% as it started say a few hours into the day

Day 2 to be 100% usage

Day 3 to be 70% usage

Since I am new at this, I am not good at explaining my desired output. But I think that is a better way to explain.

[christinepayton]

Oh, I see what you're saying. I think you'd need to split your date data into hours maybe, then you could just sum it by day. I have done something similar for calculating revenue for annual subscriptions, where you split out the amount for a year into days to calculate it, but if you're dealing with hours you're looking very granular so it could be pretty resource-intensive in PQ.  

This is the technique I used if you want to give something like this a try - this won't get you hours but the concept is similar: https://www.encorebusiness.com/blog/power-bi-how-and-why-to-add-records-between-the-start-and-end-da... 

[Idrissshatila]

Hello @jb_graphic ,

check if this is usefull https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-usage-metrics

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡

[jb_graphic]

Let me read and see if this is useful. Thanks for the information