Forum Discussion
Solved
How can I filter a table by two columns in Power BI
Hi, I have a table of order quantities, which has a date column (format: date) and a country column (text). I would like to filter this column by not using e.g. orders from US in second quarter of ...
- I would suggest creating a helper column with a formula like:
="Q"&INT(MONTH([Date])/4)+1 & "-" & YEAR([Date]) & "-" & [Country]
Then filter out "Q2-2021-US"
I suggest advanced filter. In the attached sheet you can execute advanced filter by clicking cell E5. In cells E8 and E9 you can enter the country and month you want to exclude. The criteria range is E1:E2 and cells E2 holds the rule for the advanced filter.