The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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 |
---|---|
65 | |
61 | |
60 | |
53 | |
30 |
User | Count |
---|---|
180 | |
88 | |
71 | |
48 | |
46 |