Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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:
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
Do you want to actually remove it from the table, or just simply filter those rows out from various other measures?
Ideally I would like to have removed from the table. Is this possible?
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:
Could you re-share the PBIX file again for this solution?
Thanks for the help that worked like a charm!
Hi! I would like to remove the row instead of using the filter of 0 and 1. Any suggestion?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |