Merge Table Date Order

[panagioti9]

Dear all,

I am trying to merge 3 table (excel data)in chronological order as as per below

Can you help me with that?

 

[JustynaMK]

Welcome to the forum,

Would simply merging these three tables and then sorting by "Due Date" column help?
The table order doesn't really matter in PowerBI as, once you load your data model into your report, each visualization can be sorted individually depending on the fields that were used.

 

[sandy666]

use Append feature in order 1 tbl, 2 tbl and 3 tbl
then sort Date and Desc ascending if necessary

 

[panagioti9]

Thanks both of you. however the point is that column name is not the same. ( date and due date) that we I find it more complicated

 

[sandy666]

Date	Desc	Amount		Due Date	Desc	Amount		Due Date	Desc	Amount		Due Date	Desc	Amount
01/03/2020	a	100		02/03/2020	r	120		03/03/2020	r	230		01/03/2020	a	100
05/03/2020	b	150		05/03/2020	e	230		05/03/2020	e	230		02/03/2020	r	120
13/03/2020	c	300		14/03/2020	t	350		12/03/2020	t	350		03/03/2020	r	230
												05/03/2020	b	150
												05/03/2020	e	230
												05/03/2020	e	230
												12/03/2020	t	350
												13/03/2020	c	300
												14/03/2020	t	350

// Query1
let
    Source1 = Table.RenameColumns(Excel.CurrentWorkbook(){[Name="Table1"]}[Content],{{"Date", "Due Date"}}),
    Source2 = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
    Source3 = Excel.CurrentWorkbook(){[Name="Table3"]}[Content],
    Append = Table.Combine({Source1, Source2, Source3}),
    Type = Table.TransformColumnTypes(Append,{{"Due Date", type date}, {"Desc", type text}, {"Amount", Int64.Type}}),
    Sort = Table.Sort(Type,{{"Due Date", Order.Ascending}, {"Desc", Order.Ascending}})
in
    Sort

this is not complicated ?