cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CIWEB Regular Visitor
Regular Visitor

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 same date. My data looks something like this:


 Checkin                                Checkout            Master Date

   01/02/2018                      01/04/2018            01/02/2018

   01/02/2018                      01/04/2018            01/03/2018

   01/02/2018                      01/04/2018            01/04/2018


Is there a formula for this that I should be using? I can't seem to find an easy way to do this... Any help would be greatly appreciated.

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Nick_M Senior Member
Senior Member

Re: Remove row when columns match?

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

5 REPLIES 5
Nick_M Senior Member
Senior Member

Re: Remove row when columns match?

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

CIWEB Regular Visitor
Regular Visitor

Re: Remove row when columns match?

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

Nick_M Senior Member
Senior Member

Re: Remove row when columns match?

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

Community Support Team
Community Support Team

Re: Remove row when columns match?

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)

 

dax.PNG

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
CIWEB Regular Visitor
Regular Visitor

Re: Remove row when columns match?

Thanks for the help that worked like a charm!