Merge data

[M_Elesh]

 I have two tables 

green table contain all the details & Yellow table contain same raw header without details, can I combine both to get the same blue table 

[barritown]

Hi,

Sure, like that:

[M_Elesh]

It didn't work as union needs same number of column

[barritown]

CROSSJOIN ( Yellow, VALUES ( Green[attendees] ) ) adds one missing column to the Yellow table so this solution should work. The screenshot is from DAX Studio where it worked for me.