Forum Discussion

richardnlove918's avatar
richardnlove918
Frequent Visitor
7 years ago

Power Query: Make a Record containing Tables using M

Hi all,   I am looking to create a record containing tables.  I can do this by hardcoding table names in the query ...     .... but I'm looking to do this using M providing as input a tabl...
Need Help
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi richardnlove918 ,

You could create a custom column with the formula below.

= Table.AddColumn(#"Changed Type", "Value", each Expression.Evaluate("Table1",#shared) )

Here is the output.

Best  Regards,

Cherry

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    v-piga-msft  there is a mole in this solution, you cannot use this if the table name has spaces in it eg: Student Details. it shows error in that case.

    how can we correct that.