I want to display the maximum date side by side for the dates in the table

[hide]

Hello,

Sorry for the elementary question.

I want to display the maximum date side by side for the dates in the table.

I want the maximum over all rows, not the maximum per row.

max(date) = max('Data'[Date])

What I would like is:

[hide]

Thank you! It is solved. it was very helpful.

[john_elmasry · Accepted solution]

You Can use "ALL" Function

Maximum Date = CALCULATE(max('Data'[Date]),ALL('Data'))

[hide]

When applying a filter to the table, how can I apply a filter to "min(date)" as well?

min(date) = CALCULATE(MIN('Data'[date]),ALL('Data'))

Click on another list to filter this table. How can I make it so that min(date) is also filtered?

I want to make it the minimum date after filtering.

Below is an image of what I want to do.

This kind of processing is easy with Tableau, but PowerBI is difficult.