Forum Discussion
Solved
Unifying Percentage Data Formats in a Single Column
Hello, I am trying to create a table-widget(?) that will indicate the number of patients at our health center that have a lab result that falls within certain categories (i.e. <7%, 7 to 8%, >8%)....
It would probably make sense to clean the data up in Power Query editor.
You could add a custom column , something like
if [labvalue] > 1 then [labvalue] else 100 * [labvalue]
as long as that rule holds for all of your data
