Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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..."))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
98 | |
78 | |
64 | |
56 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |