Forum Discussion
Filtering out zeroes across multiple fields
Anonymous
In Power Query, you can UnPivot all the Values columns and filter out the zero rows, this way you get the results expected.
Refer :
https://www.youtube.com/watch?v=_YjFGsS9lNY&t=23shttps://www.youtube.com/watch?v=Vff2kRBM95o&t=0s
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply š
Anonymous
In Power Query, you can UnPivot all the Values columns and filter out the zero rows, this way you get the results expected.
Refer :
https://www.youtube.com/watch?v=_YjFGsS9lNY&t=23s
https://www.youtube.com/watch?v=Vff2kRBM95o&t=0s
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply š