Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
I have a query picking rows out of a table using:
Table.SelectRows(#"DataTableSource", each (Text.StartsWith([ItemId],"QSR")))
but want to select rows starting either "QSR" or "NVI":
Table.SelectRows(#"DataTableSource", each (Text.StartsWith([ItemId],"QSR") OR TextStartsWith[ItemId],"NVI")))
but appear to be unable to slip in any OR relationship without getting "Expression.SyntaxError: Token Comma expected".
Any ideas how I fix this? (been trying for an hour unsuccessfully).
Solved! Go to Solution.
= Table.SelectRows(#"DataTableSource", each (Text.StartsWith([Column1], "QSR") or Text.StartsWith([Column1], "NVI")))
I think some of the brackets may be the issue, please give this a try.
Superstar. Thank you 🙂
= Table.SelectRows(#"DataTableSource", each (Text.StartsWith([Column1], "QSR") or Text.StartsWith([Column1], "NVI")))
I think some of the brackets may be the issue, please give this a try.
User | Count |
---|---|
97 | |
76 | |
76 | |
48 | |
26 |