Hi Everyone:
I'm new to Power BI and I'm trying to create two measurements. I'm not having lunch unforutnately. I was hoping someone could help me out? The columns are all on the same data sheet (CRO 3D). The column names are Lead Designer, Company, Project name, Estimate of total Hours, Accrued Hours, Weekly Estimate and X. (Projects ferquently switch between active and inactive, so I have a column in execl with just an X for the active ones so that I can easily filter to see only the active stuff...)
For the first formula, I would like to create a percentage of how many of the estimated hours used. First I added a new column named Percentage of Hours Used Up. Then I tried the following formula:
Percentage of Hours Used Up = 'CRO 3D'[Accrued Hours] + 'CRO 3D'[Weekly Estimate] / 'CRO 3D'[Estimate of Total Hours]
I received the following message:
Cannot convert value " of type Text to type Number
I wanted to use this calculated column to create a bar graph showing which projects are in danger of going over 100% of their estimated hours.
I also wanted to great a second graph that would add up the weekly estimates of each Lead Designer, so I could see who already has 40 hours of work allocated to them and who can take on more work...I would need to add up all of the rows that have an X in them for each designer...but I'm unable to figure out how to begin to do that? (from what little i know of PowerBI, it seems to me that would be more of a meassurement of than a calcuated column.)
Can someone let me know how to build the reports I need?
Thanks,
Jamie
