How to calculate the oldest date value in a table

[Anonymous]

I have a Table to visualize some data and I want to create a new measure to calculate the oldest date based on the table; the table shows the values based on a slicer

How to calculate de oldest date of the table based on the slicer value?

[Vvelarde · Accepted solution]

@Anonymous

The first work in a card, but if you want to include in the table use this:

OldestDate =
CALCULATE ( MIN ( Table2[Fecha] ); ALLSELECTED ( Table2 ) )

Regards

Victor

[Anonymous]

It works well. Thank you very much.

[Vvelarde]

@Anonymous

Hi, try with

OldestDate=Min(Table[Fecha])

Regards

Victor

[Anonymous]

I tried your solution but It doesn't work, It repeats the same value than the date("Fecha")