Forum Discussion
Solved
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 ...
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
amitchandak
Super User
Super Userevano_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