Forum Discussion
Replace value in a column which is using direct query mode
I have a table named system, has a column named process, which has 10,000+ values in it, now i would like to replace values named retail to mobile, using dax calculated column or any other way, Data is fetched via direct query.
evano_oruvan , Just noticed JorgePinho , already answered this. Check this update only if his update does not resolve the issue.
Not much can be done in direct query but try this a new column
if([Process] = "retail" , "Mobile", [Process])
Otherwise do it at the source
2 Replies
- JorgePinho
Solution Sage
My suggestion would be to edit the query of the direct query and do something like this:
SELECT Column1 , Column2 , CASE WHEN Process = 'Retail' THEN 'mobile' ELSE Process END AS Process_Replaced , Column3... FROM TableName - amitchandak
Super User
evano_oruvan , Just noticed JorgePinho , already answered this. Check this update only if his update does not resolve the issue.
Not much can be done in direct query but try this a new column
if([Process] = "retail" , "Mobile", [Process])
Otherwise do it at the source
