I am having the table b with the destination column. I want to replace some values dynamically.for example Destination CityWalkoutputDestination City
if new records have come the values should be changed automatically. I am using direct query
Go to Solution.
For DirectQuery your best bet is to probably create a new calculated column in DAX. You could use SWITCH or IF statement and perhaps SEARCH or FIND to do the replacements
Proud to be a Super User!
View solution in original post
Check out a full recap of the month!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.