Forum Discussion
Percentage Completed
Hi All,
I need to calculate the percentage of jobs fixed on the same day. In my dataset, I have date first on-site and date first completed, so I feel this is achievable.
Any solutions would be much appreciated.
Kind Regards,
3 Replies
Try Like
% fixed = Job fixed same day = calculate(count(table[jobid]),filter(table,table[first on-site]=table[date first completed])) Job fixed = calculate(count(table[jobid]),not(isblank(table[date first completed]))) return divide([Job fixed same day ],[Job fixed])Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on LinkedinI forget to declare variables using var
% fixed = var _Job_fixed_same_day = calculate(count(table[jobid]),filter(table,table[first on-site]=table[date first completed])) var Job_fixed = calculate(count(table[jobid]),not(isblank(table[date first completed]))) return divide([Job_fixed_same_day ],[Job_fixed])To start with also remove space from variables
