Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello guys, I'm new in the PowerQuery world, so I need a little help.
In my dataset I have a column with mixed types of variables, I need to remove the rows with null, empty and string values, keeping only the rows with numbers values, using PowerQuery. Someone can help me, please?
Solved! Go to Solution.
Issue this statement where Source should be replaced by your previous step
= Table.SelectRows(Source, each Value.Is([Column], type number))
Issue this statement where Source should be replaced by your previous step
= Table.SelectRows(Source, each Value.Is([Column], type number))
It's work!! Thank you very much!!