Forum Discussion
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 in it
thank you
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.
2 Replies
How you created this table in Power BI. Import from the source. Derived from another table?
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.
