Forum Discussion
Currency.from use
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.
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!
3 Replies
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!
Many Thanks.
Just a question: Why did you not use the Currency.From function?
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
