Card is sowing the earliest date by default and I need it to display the latest date

[rile14]

Hi All,

I need to have a card visual in the report that will show the latest date of the selected attribute. However, when I add that attribute into the card visual it is sowing the earliest date by default. Is there a way to change this?

I know that I can switch from Earliest to Latest when I'm pulling the data from Excel file, but now I'm pulling the data from the analysis services/server and that option is not available.

Thanks in advance.

[freginier]

Try this

Measure = MAX( [Date] )

[Greg_Deckler · Accepted solution]

@rile14 Well, one way would be to create a measure, MAX('Reporting Date'[Date])