Forum Discussion

CIWEB's avatar
CIWEB
Helper I
7 years ago
Solved

Remove row when columns match?

Is there a way to remove rows based on number or date matching between two columns? In this case I need to be able to remove a row only when column B (Checkout) and column C (Master Date) have the sa...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Yep and much easier ( i think ) since can leverage Power Query.  Take a look at the attached PBIX file, go to Power Query and look at the applied steps on the right hand side.  You can see each step as it happens

     

    PBIX file:

    https://1drv.ms/u/s!AoQIGRpzoxRH-lCFwaur4z5yFq3S

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Do you want to actually remove it from the table, or just simply filter those rows out from various other measures?

CIWEB's avatar
CIWEB
Helper I
7 years ago

Ideally I would like to have removed from the table. Is this possible?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Yep and much easier ( i think ) since can leverage Power Query.  Take a look at the attached PBIX file, go to Power Query and look at the applied steps on the right hand side.  You can see each step as it happens

     

    PBIX file:

    https://1drv.ms/u/s!AoQIGRpzoxRH-lCFwaur4z5yFq3S

    • CIWEB's avatar
      CIWEB
      Helper I
      7 years ago

      Thanks for the help that worked like a charm!

      • flintstone's avatar
        flintstone
        Helper II
        6 years ago

        Hi! I would like to remove the row instead of using the filter of 0 and 1. Any suggestion?

         

    • Keith011's avatar
      Keith011
      Helper III
      4 years ago

      Could you re-share the PBIX file again for this solution?