Forum Discussion

DominicK's avatar
DominicK
Helper I
6 years ago
Solved

Percent Complete between 2 columns - Underlying data is Text

https://community.powerbi.com/t5/Desktop/Percent-between-2-columns/td-p/410062   The idea is the same as the oringal thread however the underlying data is text and this is represented in PBI as a c...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi DominicK ,

    You can update the formula as below:

    % Complete =
DIVIDE ( [Vehicles Missing Returns], COUNT ( [Vehicles] ) ) * 100

    Best Regards

    Rena

DominicK's avatar
DominicK
Helper I
6 years ago

Hi az38 

 

The underlying data is text but in PBI i am using the column as a COUNT.

 

Is there a way i can divide this count, or maybe create a new column to represent the text values as numbers?

 

Thanks!