Currency.from use

[Mic1979]

Hello

I have the following:

I would like to convert the first column based on what I found in the second one, in this way:

I understood that the function to use is Currency.from, but I don't know how to combine this with the function Table.TransformColumn.

Could you suggest the code please?

Thanks.

[Mic1979]

Many Thanks.

Just a question: Why did you not use the Currency.From function?

[SundarRaj]

That is because, the Currency.From function transforms the value in that column in a Number format. Since we intend to put the currency symbol next to it as well, both of them need to be in the same data format for it to work. Besides, I don't think Currency.From attaches a currency symbol next to it, it only converts it to Power Query's currency type. Thanks

[SundarRaj · Accepted solution]

Hi @Mic1979 , instead of Table.TransformColumns, to refer to the other column without adding an another column, Table.TransformRows can be used. I'll attach the file and and the code itself for reference. Thanks!

https://docs.google.com/spreadsheets/d/15p9idYCeePT9_tNMWoJ2aaEdkpf7XG1V/edit?usp=sharing&ouid=10475...