New column in Power Query

[HaiVN]

Hell community,
I have a table in the left and an want to add one column to the table wich shows only data for 16 years as table in The right. I wonder how can I do it in Power Query? Thank you!

[DataNinja777 · Accepted solution]

Hi @HaiVN 

You can create your required output in the manner below for example.  

I attach pbix file below.

Best regards,