Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, please help me with the following question. I need to replace the text highlighted in yellow for only that cell marked in red. If I do a replace text it will also change the other exact words which I don't want to happen. Is it possible? Thanks
Solved! Go to Solution.
Hi,
In your Query Editor, add an index column and a custom column that looks for both the value you want to change and the ID that identifies the row.
Sub Category 2 = if ( [index] = 62 and [Sub Category] = "Mercadeo y Publicidad" ) then "Salario e Incentivos" else [Sub Category]
Remove Sub Category and rename Sub Category 2 to Sub Category.
Regards.
Hi,
In your Query Editor, add an index column and a custom column that looks for both the value you want to change and the ID that identifies the row.
Sub Category 2 = if ( [index] = 62 and [Sub Category] = "Mercadeo y Publicidad" ) then "Salario e Incentivos" else [Sub Category]
Remove Sub Category and rename Sub Category 2 to Sub Category.
Regards.
What data identifies that cell marked in red?
Is it the account AGUINALDO? Are there any other fields?
You could do something like:
Column = IF([Accounts] = "AGUINALDO" , SUBSTITUTE([Sub Category], "Salario...", "Mercadeo..."))
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |