Forum Discussion

Westen's avatar
Westen
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's avatar
    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

tamerj1's avatar
tamerj1
Community Champion
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

Westen's avatar
Westen
Regular Visitor
3 years ago

Thanks! That solves my problem.