Forum Discussion
Power BI Match Column Headers and Fill Rows with single Value from a Different Table?
Community Supporthi, Anonymous
Do you mean that column headers of table A is like this 2/28/2019, 3/31/2019...
If so, I suggest you to Unpivot table A or Pivot tabke B then create the relationship or merge two table.
http://radacad.com/pivot-and-unpivot-with-power-bi
If not your case, please share some sample data from table A and expected output.
Best Regards,
Lin
v-lili6-msftThanks for the reply. I sort have already tried your suggestion. I tried to unpivot and then merge the two tables. The issue is that there are no matching rows between Table A and Table B so nothing returns. If I make the join to include all rows from each table that does not really help either as the thousands of rows from Table A won't have any values in the new merged column since there are no matching rows.
I really want to just dump the value of a column in Table B into every row in Table A.
- v-lili6-msft
hi, Anonymous
Please share some sample data(or virtual data) from table A and expected output.
and if you could try Transpose function in power query
Best Regards,
Lin