Forum Discussion

YasirBilal's avatar
YasirBilal
Helper I
6 years ago
Solved

Next Year

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 i...
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    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.

v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

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.