Next Year

[YasirBilal]

Hello Everyone,

So my Question is 

i have a Dataset with year table in it 

2015

2016

2017

2018

2019

So i want to Add 2020 in my year is there any way i can create a new table with 2020 year in it

thank you

[v-alq-msft · Accepted solution]

Hi, @YasirBilal 

Based on your description, I created data to reproduce your scenario.

You may click ‘Edit Query’, go to Query Editor, select ‘Home’ ribbon, choose ‘Enter Data’, create a table as follows.

Then  you may go to ‘Queries’ area, make ‘Table’ query selected, choose ‘Append Queries’ in ‘Home’ ribbon, configure as follows.

Result:

As a workaround, you can also go to ‘Query Settings’, right-click last step, choose ‘Insert Step After’, input content with the formula ‘Table.InsertRows(#"Changed Type",5,({[Year = 2020]}))’.

Result:

If I misunderstand your thought, please show me your sample data. Do mask sensitive data before uploading. I am glad to solve the problem for you.

Best Regards,

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

How you created this table in Power BI. Import from the source. Derived from another table?