Forum Discussion
Combining Data and Dates from two different tables
Woops that just posted without me finishing. Here are conceptual examples of the two tables and the table I'd like to convert the data to.
Table 1
Company A 10 12 14 18
Company B 1 3 5 9
Company C 8 16 5 8
Table 2
Company A 1/1/2015 1/2/2015 1/3/2015 1/4/2015
Company B 1/3/2015 1/4/2015 1/5/2015 1/6/2015
Company C 12/30/2014 12/31/2015 1/1/2016 1/2/2016
Question: how do I convert these tables to this:
Company Date Data
Company A 1/1/2015 10
Company A 1/2/2015 12
Company A 1/3/2015 14
Company A 1/4/2015 18
Company B 1/3/2015 1
Company B 1/4/2015 3
Company B 1/5/2015 5
Company B 1/6/2015 9
Company C 12/30/2014 8
Company C 12/31/2014 16
Company C 1/1/2014 5
Company C 1/2/2014 8
Memorable Memberyou 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