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
View solution in original post
Check out the News & Announcements to learn more.
Congratulations, the new Super User Season 2 for 2021 has started!
Check out the new Power Platform Community Connections gallery!