Forum Discussion

Blackworms's avatar
Blackworms
Frequent Visitor
9 years ago

Power Query Lastdate & 1 Year Back Filter

Hi everyone,   I have a set of data which includes my Sales Year/Month/Day. My 2017 or current data is not daily and can vary from today's date. For example, today is 23rd of May, however the last ...
Need Help
MarcelBeug's avatar
MarcelBeug
Icon for Community Champion rankCommunity Champion
9 years ago

You can get the last date with:

 

List.Max(#"Changed Type1"[Transaction YMD Desc]])

 

In your example code you select data from 01.01.2016 tru 20.05.2016 and from 01.01,2017 thru 31.12.2017

 

I would expect a selection of anything > 20.05.2016.

 

You can get 1 year back with:

 

Date.AddYears(List.Max(#"Changed Type1"[Transaction YMD Desc]]),-1)