xMIKExSMITHx
New Member
- Joined
- Jul 11, 2014
- Messages
- 45
I have the following in my power query which pulls a forecast:
Column 8 is the current month being pulled which I adjust each month, so next month I would update that to Column9 and it would pull May's data.
I want that column to be dynamic so I dont have to update it each month, and it pulls the digit from a table (Current_Month_Selection) i drill down to giving the value of "8". I tried the below but didnt work, and I imagine I am on the right track. Any advice?
Power Query:
= Table.SelectColumns(#"Demoted Headers",{"Column1", "Column2", "Column3", "Column4", "Column8"})Column 8 is the current month being pulled which I adjust each month, so next month I would update that to Column9 and it would pull May's data.
I want that column to be dynamic so I dont have to update it each month, and it pulls the digit from a table (Current_Month_Selection) i drill down to giving the value of "8". I tried the below but didnt work, and I imagine I am on the right track. Any advice?
Power Query:
= Table.SelectColumns(#"Demoted Headers",{"Column1", "Column2", "Column3", "Column4", "Column"&Current_Month_Selection})
