Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am having the table b with the destination column. I want to replace some values dynamically.
for example
Destination
CityWalk
output
Destination
City
if new records have come the values should be changed automatically. I am using direct query
Solved! 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
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
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |