Can anybody tell me the DAX to add only particular values of a field in new calculated column?

[shivam]

PS : I am working on direct query mode so don't have access to the Power Query

I want only 3 particular values (by name) in new calculated column. example- "apac", "emea", "usca"

[amrans]

If you are using direct query with SQL Server, check if you can call a custom query to add required column logic in query.

[amitchandak · Accepted solution]

@shivam , There is a limitation  not type of operation you can to in direct query for column

You can try three new columns, simple if, may work

example

if [Region] = "apac" then [column]