Using a date slicer with a Card but just showing the last value

[DataGeo]

I have a date slicer on one page and also a card. The card is numerical data in columnar form which has a date (single day) associate with each day. 

With the slicer in a range, it only gives me the options to "sum, average, minimum, etc. etc.".

What I want is the LAST value, so only the value for the end range of the slicer. Not sure how to accomplish this.

Thanks!

[Phil_Seamark · Accepted solution]

Hi @DataGeo

Is this calculated measure what you mean?  My table is called Table, and the two columns are [Date] and [Value]

Measure = 
VAR d = LASTDATE('Table'[Date])
RETURN 
    SUMX(
        FILTER(
            'Table',
            'Table'[Date]=d),
            'Table'[Value])

[Anonymous]

Hi, It works fine if you use the Date column in the same Table, but I'm using a Date hierarchy that is in a Calendar Table and it doesnt work. Can anybody helpme? 

[DataGeo]

Nailed it! Thank you!