Announcements
Hello Community,
I want to know if the proposed syntax is right?
As a whole, only rows 1, 2 and 3 work for me, but rows 4 and 5 do not filter me.
If I raise individually 3, 4 and 5, the filter works for me.
Some help
hi @fgonzalez515
sample Download the Financial Sample Excel workbook for Power BI
Try it !
Hi @ZS440,
I tried this
But I also get other results, not those of the syntax
But in my excel it managed to filter my syntax
Hi again @fgonzalez515
I want you to take a closer look.
Note the use of brackets.”( )”.
SELECT * FROM [Sheet1$] WHERE [Date] between #2014-01-01# and #2014-04-30# AND ([Country] ='Canada' OR [Country]='Mexico') AND([Product]='Carretera' OR [Product]='Amarilla' OR [Product]='Montana');
Thanks.
I managed to get everything with your observation.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Haque 608
Valantis 416
11manish 348
