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

3 Replies

  • 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

       

       

  • 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