Forum Discussion

soni27's avatar
soni27
Icon for Helper I rankHelper I
5 years ago

Variable in Column Name in Power Query in Drill Down

I have LastColumnName Step in the Power Query   I would like to drill down using LastColumnName I tried below,  It is not working, please assist = Custom2{0}[Record.Field(_, LastColumnName)]
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

What does the step LastColumnName = ? Also, when you say "drill down", do you want to return the value from the last column in the first row, or a list of all the values in the last column. Finally, what is the actual column name at this step?

 

Thanks! -- Nate