Solved: How to: Unstack Data

ahadi063 · ‎12-20-2017

Hi everyone!

I am new to BI and was wondering if someone would be kind enough to help with a problem I am facing.

Please see attached the output format that I am getting from a reporting tool and I need it to transform it as how it is seen in "Desired look" tab.

This is the following transformation that I need:

1. Be able to put all the variables to headers and transform it as columns.

2. Be able to delete the all the rows associated with "Weekly Summary".

If anyone can help that would be great!

v-chuncz-msft · ‎12-21-2017

@ahadi063,

You may directly Connect to data in Power BI Desktop and transform the data in The Query Editor.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-chuncz-msft · ‎12-21-2017

@ahadi063,

You may directly Connect to data in Power BI Desktop and transform the data in The Query Editor.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.