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