Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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 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/
Thank you Mnayar 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |