Forum Discussion

RAHIMANMD's avatar
RAHIMANMD
New Member
8 years ago
Solved

transform data from rows to columns in power bi

Hi ,

 

We have requriement to transform rows to columsn based on date dimention as menction in the below screen shots. Ideally we are expecting to transform the monthly dollar and unit data with a date dimension using the current year and month .every month will get flat file from that month 52 month need to show Units in the coloums and menctioned in the 2 nd screen shot. 

 

any one have idea how to transofrm data to coloumns to rows.please let me know.Thanks

  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    Hi RAHIMANMD,

    We have requriement to transform rows to columsn based on date dimention as menction in the below screen shots. Ideally we are expecting to transform the monthly dollar and unit data with a date dimension using the current year and month .every month will get flat file from that month 52 month need to show Units in the coloums and menctioned in the 2 nd screen shot. 

     

    any one have idea how to transofrm data to coloumns to rows.please let me know.Thanks

     

    For your scenario, you could have a reference of this blog Pivot and Unpivot with Power BI. 

     

    Best Regards,

    Cherry

1 Reply

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    8 years ago

    Hi RAHIMANMD,

    We have requriement to transform rows to columsn based on date dimention as menction in the below screen shots. Ideally we are expecting to transform the monthly dollar and unit data with a date dimension using the current year and month .every month will get flat file from that month 52 month need to show Units in the coloums and menctioned in the 2 nd screen shot. 

     

    any one have idea how to transofrm data to coloumns to rows.please let me know.Thanks

     

    For your scenario, you could have a reference of this blog Pivot and Unpivot with Power BI. 

     

    Best Regards,

    Cherry