Forum Discussion
Power Query | Show Additional Column Each Day
Hi,
I need help with the following and if possible I don't want to transpose the table because I know it's an option but I think there's a better way (that's where I need you guys...
FOr example I have a raw data that has 5 columns(in reality I have more), and column names are exactly as below
Column1, Column2, Column3, Column4, Column5
Today I only want to retrieve >>>> Column1
The next day >>>> Column1, Column2
and the next >>>> Column1, Column2, Column3
and so on...
How can I do that using Power Query?
Check out this article on Power Query. Specifically, referring to columns by their index number, specifically the "Use Column Indices" section mid-way down. It may point you in the right direction.
1 Reply
Check out this article on Power Query. Specifically, referring to columns by their index number, specifically the "Use Column Indices" section mid-way down. It may point you in the right direction.