GooberTron
Board Regular
- Joined
- Oct 13, 2012
- Messages
- 217
I've just about progressed beyond the main Power Query interface, and getting a better grip of simple M Code.
Most of my transformation needs can be sorted out using various Unpivot, Pivot, Transpose, Fill Down type things. I've happily worked through "Master Your Data..." v2 and it's been really helpful.
There are, however, a few jobs where I'm now resorting to grabbing specific column/row values as variables in order to shuffle things around and create new columns with this metadata copied down.
I mean, it works (providing nothing changes in the report layouts), but I can't help feeling it's a bit unsophisticated and reminds me of how I might have done this in VBA (though there I would use search functions and offset row / columns to find metadata in workbooks).
Anyone got any wise words or learning resources for me? At the moment, the only alternative I can see would be to have multiple queries of the same table and append or join things together later - but holding a few things as hard coded variables keeps everything in the same query.
Thanks
Most of my transformation needs can be sorted out using various Unpivot, Pivot, Transpose, Fill Down type things. I've happily worked through "Master Your Data..." v2 and it's been really helpful.
There are, however, a few jobs where I'm now resorting to grabbing specific column/row values as variables in order to shuffle things around and create new columns with this metadata copied down.
I mean, it works (providing nothing changes in the report layouts), but I can't help feeling it's a bit unsophisticated and reminds me of how I might have done this in VBA (though there I would use search functions and offset row / columns to find metadata in workbooks).
Anyone got any wise words or learning resources for me? At the moment, the only alternative I can see would be to have multiple queries of the same table and append or join things together later - but holding a few things as hard coded variables keeps everything in the same query.
Thanks
