Forum Discussion

Mic1979's avatar
Mic1979
Post Partisan
1 year ago
Solved

How to use expression (x,y,z)

Dear all,   does anyone know if there is some resource to understand how to use    For example, I got in this forum indications to write the following custom function:   (Input_Table as table) ...
Tutorial Requests
  • dufoq3's avatar
    dufoq3
    1 year ago

    Hi Mic1979, you hardcoded "InputColumn1" and "InputColumn2" in UnPivotedTable step:

    Replace UnPivotedTable step with this:

     

     

    Table.UnpivotOtherColumns (AddIndex, {InputColumn1, InputColumn2}, "Attribute", "Value")

     

dufoq3's avatar
dufoq3
Community Champion
1 year ago

Why do you need function? You can replace separately. 

1st replace Bronze and afterwards replace Brass

 

 

Mic1979's avatar
Mic1979
Post Partisan
1 year ago

Hello 

I want to manage this through a function because I want to use this custom function also for other columns, where I can change the content of the second and third column based on the values of the first.

 

I think the custom function I wrote could cover my target, but I really don't understand the reasonof the error message I get. 

 

Hoping this explains my willing.

 

Many thanks for your support.