cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Syndicate_Admin
Administrator
Administrator

Add column to inner table of a column

Hello,

 

I would be grateful for any tips on the following problem.
I have a table like this:

and been trying to place value in column Date into each inner table of Data column. I know that I can simply expand Data column and the Date will stay within each row. However I need to combine those two tables into one. I am using 

 

=Table.Combine(Custom2[Data])

 

as the next step, however it eliminates Date column. How can I place Date into the inner tables as a separate column that stays in place after I combine the two tables? 

Thank you.

2 REPLIES 2
Syndicate_Admin
Administrator
Administrator

= Table.Group(Custom2, "Date", {{"Data", each Table.Combine([Data])}})

Thank you. However I get "column 'Data' of the table wasn't found". 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,073)