OR in Expression

[evansabres]

I have an expression that is structured as such:

=SUM({$<promoCDE={"MP1"}>}[Net Sold Qty])

However, I have several 'promoCDE' types that begin with MP that are the same as MP1 (MP1, MP1BOX, MP3, MP3BOX, MP6)

I want to build in the expression to pull all of these. How do I structure that using an OR statement???

[sunny_talwar · Accepted solution]

Try with wildcard search:

=Sum({$<promoCDE={'MP*'}>}[Net Sold Qty])

[evansabres]

That works perfectly, thank you for your help

[evansabres]

That worked perfectly. Say however that I wanted to include several 'promoCDE' within this expression For example, if I wanted to include the promoCDE's of '2FAMPK' 'GR' 'YTHHOC'

How would I structure this using an OR statement??

[sunny_talwar]

Then you can do this:

=Sum({$<promoCDE = {'2FAMPK', 'GR', 'YTHHOC'}>}[Net Sold Qty])