Filter criteria with OR on multiple columns

[Turbo_Vaughan]

Hi, I'm very new with PowerBI, so please treat me as a complete newby. I'm sure this is easy but I'm scratching my head here.

I need to filter a table of orders to show only orders where [status] is not "C" (i.e. current, not completed orders) OR [completion_date] is in the last 6 months. When I filter status using the column header, obviously all "C" status items are filtered out. The question is how to apply an OR filter criteria across the two columns.

Thanks for any help. 

[Turbo_Vaughan · Accepted solution]

OK, I had a play around and got there quite quickly:

= Table.SelectRows(scheme_bmwohm, each ([status] <> "C" or Date.IsInPreviousNMonths([completion_date], 6)))

Should have had more confidence to start with.