cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
madji Regular Visitor
Regular Visitor

Advanced Editor

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

 

1 REPLY 1
Highlighted
v-ljerr-msft Super Contributor
Super Contributor

Re: Advanced Editor

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. Smiley Happy

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