Forum Discussion
Anders_G
Helper I
Helper IFilter by same period last year (data import)
I connect to a data set that is very heavy, so I have to limit each data import to the previous 30 days. I do one data import for the previous 30 days this year using the standard date filters. ...
amitchandak
Super User
Super UserAnders_G , You can get 4 dates like this in power query and use that to filter data
Date.From(DateTime.LocalNow())
Date.AddDays(Date.From(DateTime.LocalNow()),-30)
Date.AddYears(Date.From(DateTime.LocalNow()),-1)
Date.AddYears(Date.AddDays(Date.From(DateTime.LocalNow()),-30),-1)
Anders_GHelper I
Helper IThank you. But where exactly do I add this?