Advanced Editor

[madji]

Hi , folks)

Can you help me?

I want to load only 1 years - (2017) from date.

But i don't know how it will write in Advanced Editor. Maybe,

Do you have any examples?

TNK

[v-ljerr-msft]

Hi @madji,

I'm not sure I can understand your requirement totally. Do you want to create a Calendar table for year 2017? Or filter your source table to load data for year 2017?

For both scenarios, you can refer to the follow two articles. 

https://michaeladrianjohnson.com/2017/08/01/creating-a-custom-date-table-using-powerquery/

https://support.office.com/en-us/article/Filter-a-table-Power-Query-b5610630-f5bf-4ba4-9217-a628f9b8...

Regards