transform data from rows to columns in power bi

[RAHIMANMD]

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 · Accepted solution]

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