Forum Discussion

SJHALANI's avatar
SJHALANI
Icon for Helper I rankHelper I
3 years ago

Table transformation in Power BI

Hi All,

I have been struggling with transforming a given table to a specific format.

Currently, My table is in this format

I want to transform this table to the format given below:

 

There are 100s of such currencies in the 1st table.
I want to know what transforation steps could help me get to the desired output. Any help is appreciated. TIA!

Show and Tell

1 Reply

  • Dhairya's avatar
    Dhairya
    Icon for Solution Supplier rankSolution Supplier
    3 years ago

    Hey SJHALANI 
    for getting your expected output you have to pivot your columns.