Filter by first letter or character

[Emir_power]

Hi Everyone,

I'm trying to filtering a column by the first two charachter

Quantity 97*** = CALCULATE(SUM(Invoices[Quantity]); Invoices[ShipPostalCode]  IN {"97***"})

ShipPostalCode

97403

97827

99362

97219

99508

How to get just the 97*** ShipPostalCode

Any help would be appreciated. Thanks! 🙂

Emir

[Anonymous · Accepted solution]

@Emir_power create a calculated column with the first 2 characters using LEFT and then use that in your query you mentioned above.

IN Clause - https://www.sqlbi.com/articles/the-in-operator-in-dax/

[Emir_power]

Thank you Mnayar 🙂