Help with Same year + previous 5 years DAX formula

[willow1985]

I am brand new to Power BI. I would consider myself a advanced user in excel but am struggling getting started with Power BI.

I just converted/made a new column for dates that were converted from Unixtime (was not easy to figure out). Now I just need to add a filter to only bring in the last 5 years including the current year.

I cant seem to get the current year. How would I modify this DAX formula to include the current year as well?

= Table.SelectRows(#"Changed Type", each Date.IsInPreviousNYears([Date Received], 5))

Any help would be greatly appreciated!

 

[mart37]

= Table.SelectRows(#"Changed Type", each Date.IsInPreviousNYears([Date Received], 5) or Date.Year([Date Received]) = Date.Year(Date.From(DateTime.LocalNow())))

 

[willow1985]

Works perfect! you are a life saver!

I have so much to learn so I know I will be on this board a lot. Thank you again!