How to make a dynamic calculated calendar table?

[JustinDoh1]

I am trying to make this area (in orange box) dynamic:

I have uploaded my PBI file here:

What I am trying to do is, replacing the static values of "2024, 5, 31" with latest date from one of tables inside PBI file.

So,  either get the latest "Processing Date" or "New Processing Date" from either Table_1 or Table_2 and stick the value there instead of "2024, 5, 31".

Is it possible?

How do I express that?

[vicky_ · Accepted solution]

You should be able to replace the DATE() part with MAX(MAX(Table1[Processing Date]), MAX(Table2[New Processing Date]))