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...
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?