Forum Discussion

shawn3474's avatar
shawn3474
Frequent Visitor
8 years ago

Calculating Resource Capacity

I am trying to calculate resource utilization to display weather a group is being over utilized.  I know I can pull it in table view to display total hours used and total hours available but I want t...
Need Help
shawn3474's avatar
shawn3474
Frequent Visitor
8 years ago

OK I got this working.  Thank you so much for the guidance.  The part I am stuck on now is that in Step 1 when I create the table it tallies everything since inception.  Is there a way to introduce a slicer into this?  Right now I am using a filter on the query to accomplish this but I would like to be able to slice it so that I can look at last weeks data for historical purposes without having to change the query filter. 

 

 

v-xjiin-msft's avatar
v-xjiin-msft
Solution Sage
8 years ago

Hi shawn3474,

 

What kind of slicer? Please share us the logic and your desired result.

 

Thanks,
Xi Jin.

  • shawn3474's avatar
    shawn3474
    Frequent Visitor
    8 years ago

    So the data goes back several years.  I want to be able to look at a period of time.   What I have done for the interim is placed a filter on the query to only import data from the last 7 days.  Ideally though, I would like to be able to adjust the time frame as needed.

    • v-xjiin-msft's avatar
      v-xjiin-msft
      Solution Sage
      8 years ago

      Hi shawn3474,

       

      Sorry for the delay.

       

      What's the relation between this time and above data? Could you please share us a sample pbix file with One Drive or Google Drive if possible?

       

      Thanks,
      Xi Jin.

      • shawn3474's avatar
        shawn3474
        Frequent Visitor
        8 years ago

        No worries.  I am closing this topic out as I am changing direction a bit.