Changing one value of row to column [closed]

Question

I am working on a Power BI report. There are two dimensions DimWorkedClass and DimWorkedService. (The above snippet is obtained by exporting matrix values to csv.)

The requirement is to transform only the Worked Service Text5 into the Worked Class of Text5 as opposed to A (which is the current value).

It can be transformed at the backend, but is there any way to do it in Power BI?

Answer 1

This is trickier than it might appear, but it looks like this question has already been answered here:

Power Query Transform a Column based on Another Column

In your case, the M code would look something like this:

= Table.FromRecords(Table.TransformRows(#"[Source or Previous Step Here]",
      (here) => Record.TransformFields(here, {"Worked Class",
          each if here[Worked Service] = "text5" then "text5" else here[Worked Class]})))

(In the above, here represents the current row.)

Another answer points out a slightly cleaner way of doing this:

= Table.ReplaceValue(#"[Source or Previous Step Here]",
      each [Worked Class],
      each if [Worked Service] = "text5" then "text5" else [Worked Class],
      Replacer.ReplaceText,{"Worked Class"})