Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!!