Forum Discussion
Resource Usage
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.
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.
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/