Latest date value in Card visual

[Anonymous]

Hi,

I have data which has rows as dates, against which counts(column IT) for that month are listed for a BU.

I want to create a card visual where the latest date's count is displayed and then tie it to a month slicer where when I click on a month it shows the count for the selected month.

Currently, when I choose the column IT onthe card visual it sums up the counts for all months.

Eg-

Date	IT
Jan	1
Feb	2
March	3

 I want my card to show 3 but it shows 6 as default.

Then when i go ahead and select Feb I only want to see 2.

What can be done here?

Thanks !

[amitchandak]

@Anonymous , Hop you have Date not month

Try like

lastnonblankvalue(Table[Date], sum(Table[IT]))

[Anonymous]

This did not work, but I used another formula that helped!

But thank u for responding!