Forum Discussion

jb_graphic's avatar
jb_graphic
Frequent Visitor
2 years ago

Resource Usage

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

5 Replies

    • jb_graphic's avatar
      jb_graphic
      Frequent Visitor
      2 years ago

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

  • christinepayton's avatar
    christinepayton
    Most Valuable Professional
    2 years ago

    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's avatar
      jb_graphic
      Frequent Visitor
      2 years ago

      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's avatar
        christinepayton
        Most Valuable Professional
        2 years ago

        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-date/