Forum Discussion
Data Transformation and PowerBI/PowerQuery
Do the following:
1) Right click on the Departments colum , click Fill=>Down
2) Filter out blanks from Year/Month
I would actually stop here and keep the 3 column layout - with it you can achieve the view you want using the Matrix visual, plus it's much easier to manage with time hierarchy etc (you can actually do joins with a Calendar table, use time intelligence etc.) Still, if you really need that layout in PQ then
3) Pivot column Year/Month in the Transform ribbon
Do the following:
1) Right click on the Departments colum , click Fill=>Down
2) Filter out blanks from Year/Month
I would actually stop here and keep the 3 column layout - with it you can achieve the view you want using the Matrix visual, plus it's much easier to manage with time hierarchy etc (you can actually do joins with a Calendar table, use time intelligence etc.) Still, if you really need that layout in PQ then
3) Pivot column Year/Month in the Transform ribbon
Works great! It makes so much sense now. I was getting hung up on the Fill Down and blanks to null.
Thanks!
