Forum Discussion
Power Query today plus 2 years
Hi, I have a Power Query which produces an expanded list of dates from the start and ed date columns in my table. One part is: if EndDate = null then (Date.From ( DateTime.LocalNow() ) else E...
ok brill thanks. What if I wanted the date to be the maximum of a particular column (e.g. the maximum date in the end date field) rather than a 2 years fixed from each day going forward?
You need to user GROUP BY as below.
After that expand the Expansion column.
Then create a column as below.
Then delete the unnecessary columns.
If it hleps, mark it as a solution
Kudos are nice too
and what if that end date is in a different table?
for instance I see this here (https://stackoverflow.com/questions/50457881/how-to-find-the-most-current-date-from-a-column-in-power-query-max/50473350) but when I try it it only allows me to use columns in the table I then used with this custom function.