NEED HELP How to check more than 10000 Conditional statements in POWER BI

[grprem81us]

 POWER BI DESKTOP : NEED HELP

I have a list of Phone numbers for which i need to find their telecom operators based on beginswith country code.

It works fine for a list of 500 or 600 List of Operator details. When the Details increase to 10000 then it throws Errors "Query too long to run"

Can anyone suggest me an alternative way ? Thanks in Advance

[v-cherch-msft]

Hi @grprem81us

It seems you may try to add condition column in Query Editor or create a column or measure with IF Function and IN Function to match your condition. Here is the reference for you.

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

Regards,

Cherie