DAX - dates add in existing table

[Anonymous]

Hi Every one,

I have table with "Date" & Sales data.

I want to add Future Date values in to my existing table.

ex: data in table "01/01/2017" to 07/03/2019" 

i want to add data in same table in the date field "08/03/2019" to 07/03/2020"

i have provided sample data in this link.

Thanks in advance.

Rg 

Venu

[Nolock]

Hi @Anonymous,

just for better undertanding: Do you have another table with 2 columns which you should append to the original table?

[Anonymous]

@Nolock Thanks for your response....

If my datasource is "SpreadSheet". your answer is perfect. if have any other datasource.

i just given my data in excel only.... i need to add those dates at "Power BI Desktop" level using "DAX".

[Nolock]

Hi @Anonymous,

I've created 2 tables in Excel, MyTable1 and MyTable2.

After that I imported both of them in Power BI.

Then I appended MyTable2 to MyTable1.

And the result is: