How do I default the max date of a table as a default value in a Date prompt in a dashboard?

[amit_kothari]

The usecase here is how to calculate the max date from a table column and then default that to a date prompt in a dashboard. 

[amit_kothari · Accepted solution]

Here is Anurag's video that shows how to calculate max date from a table column and default that to a date prompt in the dashboard: https://youtu.be/9CdKnTh2CiM