Remove rows based on data in another column

[Westen]

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-10-02	C	1232
2022-09-01	2022-10-03	B	1233
2022-09-01	2022-09-01	B	1234
2022-09-01	2022-09-02	A	1235
2022-09-01	2022-09-03	C	1236
2022-09-01	2022-09-01	B	1237

I want to filter out rows in “date 2” column that don’t match the same month in “Date 1” column.

Expected result should be:

Date 1	Date 2	Value 1	Values
2022-09-01	2022-09-01	B	1234
2022-09-01	2022-09-02	A	1235
2022-09-01	2022-09-03	C	1236
2022-09-01	2022-09-01	B	1237

Anyone that can help me out here?

[tamerj1 · Accepted solution]

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

[Westen]

Thanks! That solves my problem.

[lukiz84]

In PowerQuery or in DAX? If DAX, what do you want to calculate?

[Westen]

I want to remove them in PowerQuery.