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

= Custom2{0}[LastColumnName]

--Nate

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

It is not working,  I can not able to drill down using variable Name for the column name