Forum Discussion

Regular Visitor

3 years ago

Solved

Remove rows based on data in another column

Hello Need help filter out data in a dataset I have a table that looks like this: Date 1 Date 2 Value 1 Values 2022-09-01 2022-10-01 A 1231 2022-09-01 2022-1...

Need Help

tamerj1
3 years ago
Hi Westen

I'm not a power query expert but you can add a conditional flag column somthing like

each if Date.Month ( [column1] ) = Date.Month ( [column2] ) then 1 else null

then you can filter out the blanks