Import Data Using Variable Filter

[kevinsray]

I am wondering if someone could help a noobie out.

I have a report where I am importing data from a table with 10+ years of data, and am using dateadd to get the last 3 years only.

However, what I really want to do is only get data from 1st Jan last year.

Is there any way to do this?

[V-pazhen-msft · Accepted solution]

@kevinsray 
You cannot filter before you importing, what you can do is filter the imported data to show last N years values.

The easiest way I can think of is Relative Date Slicer or Filter on the date column.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[AlB]

@kevinsray 

Share some sample data that can be copied (not scree cap) and I will give the example

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[AlB]

Hi @kevinsray 

You can do this best in Power Query. Filter the date so that you only keep dates after the day you want

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[kevinsray]

OK. That sounds great.
But I am not sure how to do that.

Any chance that I could get an example?

[AlB]

@kevinsray 

See if this helps

https://community.powerbi.com/t5/Desktop/Filter-query-by-date-column/td-p/333186

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[kevinsray]

I had a look, but I don`t want the last X months.
I want from 1st Jan last year (2019).
And when we get to 1st Jan 2021, it should automatically change to 1st Jan 2020.,