Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Saad L.]

Hello there,

I want to use the dax FILTER function to search for values ??in the form “GMXXX”, or which starts with “GM”.

How could i do that?

FILTER(MarketSales;MarketSales[Country]=”GMXXX”) ?

Thank you in advance

——————————
Saad L.
——————————

[Eric Lofstrom]

Saad – 
You’ve almost got it – just use a comma instead of a semicolon and the LEFT function to get anything starting with “GM”.
So FILTER(MarketSales, LEFT(MarketSales[Country], 2) = “GM”)).
Of course, FILTER returns a table so you’ll need to do something with it like COUNTROWS or something like that.
Eric

——————————
Eric Lofstrom
Principal
BlueGranite Inc.
elofstrom@blue-granite.com
Join me each month for Power BI Office Hours!
https://www.blue-granite.com/power-bi-office-hours
——————————
——————————————-