Forum Discussion
automaticly append 2 tables
Dear all, i have a table that gets an update every year. i already appended both of them. In the old i filter the years 2017-2021 (e.g) and in the new one i filter 2022-2028 (the new one always com...
Hi Vandergledison,
My understanding is you have 2 tables, both applied filter and mutually exclusive. You want to automate them so you don't have to change the filter.
Questions:
1. Are you using Power BI or Excel?
Solution:
1. If you're using Power BI, then you can use the incremental load as per ImkeF
2. If you're using Excel, you can achieve it with an Input table.
3. Add a formula to each query prior appending them.
e.g. Table 1: Table.SelectRows(#"Previous Step", each [Column - Year]<Date.Year(DateTime.LocalNow()) )
Table 2: Table.SelectRows(#"Previous Step", each [Column - Year]>=Date.Year(DateTime.LocalNow()) )
Regards
KT