SAP BW - How to write conditional M statement to pass a range of values as a parameter

Hi community,

I am new in general to editing power query code so please be gentle and explicit in your guidance 🙂 I am querying SAP BW, and trying to limit data extracted (vs. filtering after it loads in PQ).

In the highlighted step below, I would like to not have to specify individual values, and instead, either use:

• a range of values (10000091220000 - 10000091229999)
• a wildcard (1000009122*)
• an if loop (if [!V000010] starts with 1000009122, then grab the record, else don't)

Add Items expects individual selection for this parameter (see below). Is what I want to do even possible?

TIA