Forum Discussion
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-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?
4 Replies
Thanks! That solves my problem.
In PowerQuery or in DAX? If DAX, what do you want to calculate?
I want to remove them in PowerQuery.
