Power Query: Remove duplicates but instead only zeros RRS feed

  • Question

  • Hi there

    I have a big excel document and have just discovered Power Query. 
    I found the function of removing duplicates very useful to remove rows that only contain zero, however, I later found that some of my numbers are similar, and therefore the function also removes them. 

    I'm looking for a feature that can remove the rows (and eventually also columns) that contain only zero. So if a whole row contains nothing but zeros, it should be removed. 

    Is that possible?

    Thanks in advance!

    Monday, June 25, 2018 9:38 AM