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
Learn how to create your own user groups today!
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!