Using end date from ultimate calendar in other Table query

[Joho70]

Im using this Query to change non planned end date, cell with "Null" to a date in my New test list Table, column "DateofSOfortask"

= Table.ReplaceValue(#"Changed Type1",null,#date(2022, 12, 31),Replacer.ReplaceValue,{"DateofSPfortask"})

Unfortunatley this is a fixed date and I would like to use the end date from - "Calendar table", How to I do this

Im using a version of "The Ultimate Calendar" by Avi Singh where I can set a End date in the Query of that table

BR/Johnny

[amitchandak · Accepted solution]

@Joho70 ,

Have you tried using List.Max(Calendar[Date]))  ?

[Joho70]

Tnx for a quick response, did you test your proposal with good results?