how to link date headers columns with date table

[PJ1981]

I have revenue for 1000+ customers month on month recorded in excel columns. I hasve also added date table. I need to link these date column headers with date hierarchy table.

Please see sample data: 

Product group	Segment	Revenue type	Volume type	31-Jan-18	28-Feb-18	31-Mar-18	30-Apr-18	31-May-18	30-Jun-18	31-Jul-18	31-Aug-18	30-Sep-18	31-Oct-18	30-Nov-18	31-Dec-18	31-Jan-19	28-Feb-19	31-Mar-19	30-Apr-19	31-May-19	30-Jun-19
Seaborne Trade Intelligence	Broker	Revenue - Fees	Charterparties	--	12	12	1	2	3	4	5	5	6	1	1	1	1	1	1	1	1
Seaborne Trade Intelligence	Others	Revenue - Fees	Charterparties	--	10	--	1	2	3	4	5	6	--	1	1	1	1	1	1	1	1
Seaborne Trade Intelligence	Broker	Revenue - Fees	Charterparties	2	9	4	8	4	3	5	1	5	6	10	16	8	13	16	6	10	14
Seaborne Trade Intelligence	Broker	Revenue - Fees	Charterparties	2	3	4			1	1		1		2	3	1	3	2	2	1	2
Seaborne Trade Intelligence	Broker	Revenue - Fees	Charterparties	--																	2

[amitchandak]

@PJ1981 , Unpivot the date column, that is the best way to deal with this data

https://radacad.com/pivot-and-unpivot-with-power-bi

Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g