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

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi CIWEB,

 

You also could use dax expression to create a calculated column and use it as the visual level filter.

 

Column = IF('Dates 2'[Checkout]='Dates 2'[Master],0,1)

 

 

Best Regards,

Cherry