Forum Discussion
Solved
Trying to filter out rows based on 2 date columns
I'm basically trying to do a SQL WHERE clause that says WHERE RptPEDate = APDate
Create the filter normally using the dropdown and type in any date. This will get the function written.
Then remove your manually typed/selected date with the date column you are comparing to. For example:
= Table.SelectRows(#"Changed Type", each [Date2] = [Date1])
Create the filter normally using the dropdown and type in any date. This will get the function written.
Then remove your manually typed/selected date with the date column you are comparing to. For example:
= Table.SelectRows(#"Changed Type", each [Date2] = [Date1])Worked perfectly... went into the Advanced Editor and swapped out the date with my report date column. Thanks much!
