Formula Help Currency

[erhan_79]

Hi there ;

i nned your kind supports for below issue ;

i have two table one of them table A and the other one Table B

İ have date and currency type on Table A and i would like to create a new column currency amount which is in table B as below

but i will create on power query side so could you pls give me the formula for query side 

thanks 

[harshnathani]

Hi @erhan_79 ,

I think you can use the merge query Option.

Regards,
Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

[erhan_79]

thanks @harshnathani 

but i made a mistake i showed wrong table B , so i have Table B as below , for this kind of situtaion i can use merge too , what do you think ?

[Fowmy]

@erhan_79 

Yor Table B and New Table A are same, what are you trying to achieve?
Do you need to just duplicate the table?

[erhan_79]

Dear @Fowmy  ;

sorry i made a mistake while showing table B , now you can see table A and Table B are different type 

[Fowmy]

@erhan_79 

You can select the Date column in Table B, right-click and choose  "UnPivot Other Columns"

If you are satisfied with my answer, please mark it as a solution so others can easily find it.

Don't forget to give KUDOS  to replies that help answer your questions

Subscribe to ExcelFort: Learn Power BI, Power Query and Excel  

[harshnathani · Accepted solution]

Hi @erhan_79 ,

In Table B,

Selct the Date Column and then unpivot Other Columns.

Regards,

Harsh Nathani