Forum Discussion
Percent Complete between 2 columns - Underlying data is Text
Hi DominicK ,
You can update the formula as below:
% Complete = DIVIDE ( [Vehicles Missing Returns], COUNT ( [Vehicles] ) ) * 100Best Regards
Rena
Hi Anonymous
We are almost there! thank you!
I had to change the formula slightly to the below, now the last step is to multiply the value by 100.
would this take place in the DAX formula?
The top row should read 24%
40/166*100=24
Hi DominicK ,
You can update the formula as below:
% Complete =
DIVIDE ( [Vehicles Missing Returns], COUNT ( [Vehicles] ) ) * 100Best Regards
Rena
Anonymous
Thanks this works now, I do have some of the percentages that are calculating not completely accurate.
Can I send you the data and explain the measures I have created so you can look through and advise?
Thanks,
Dom
Hi DominicK ，
Please provide some source data in table "Raw" (include the field Vehicle Name, Vehicles and Cumulative Returns - YTD (03/2020) and so on) and the correct value of % Complete, then we can provide you the proper formula.
Best Regards
Rena
Anonymous How do i upload the file?
Hi DominicK ,
You can upload it to OneDrive for Business and share the link with me.
Share OneDrive files and folders
Best Regards
Rena
Thanks Rena - I have messaged you the link
Anonymous