Forum Discussion

chanakah's avatar
chanakah
Frequent Visitor
3 years ago
Solved

Measure for calculating work capacity

I have a Power BI report. In that I need to calculate the 'remaining work capacity' for each date as below. 1. I have a measure that gives 'total remaining work hours', say 500 hours. 2. I have a...
Need Help
  • chanakah's avatar
    chanakah
    3 years ago

    Hi Anonymous ,

    Thank you for your sugestions. I was able to solve the issue using POWER function. Also here I am using GENERATESERIES function for getting total work hours calculated upto given date. 
    My measure logic is as below

    Best regards,

    Chanaka H

     

     

chanakah's avatar
chanakah
Frequent Visitor
3 years ago

Hi Anonymous ,

Thank you for your sugestions. I was able to solve the issue using POWER function. Also here I am using GENERATESERIES function for getting total work hours calculated upto given date. 
My measure logic is as below

Best regards,

Chanaka H

 

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi chanakah ,

It's glad to hear that your problem has been resolved. And thanks a lot for sharing your solution here. Could you please mark your post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours.

Best Regards