Forum Discussion
Combining Data and Dates from two different tables
you might try,
in query editor to un-pivot both tables
then merge tables
in a database one can't do that but here in Power BI the simple ordering of the rows may allow that to work
Assuming that your tables' layout will always match at a cell level (as you show it in your dummy data), I would unpivot both tables, add an index column, then merge on the index column. This should get all the values for each date in the appropriate rows.
jdata assuming your data does match as dkay84_PowerBI says
all you really need is the Index in each table - duh! :smileywink:
Assuming that your tables' layout will always match at a cell level (as you show it in your dummy data), I would unpivot both tables, add an index column, then merge on the index column. This should get all the values for each date in the appropriate rows.
jdata assuming your data does match as dkay84_PowerBI says
all you really need is the Index in each table - duh! :smileywink:
Thanks guys ! This is all very helpful! :smileyvery-happy:
