topic Re: Latest date value in Card visual in DAX Commands and Tips

Latest date value in Card visual

Anonymous — Thu, 17 Sep 2020 18:57:06 GMT

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 !

Re: Latest date value in Card visual

amitchandak — Fri, 18 Sep 2020 01:47:25 GMT

Anonymous , Hop you have Date not month

Try like

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

Re: Latest date value in Card visual

Anonymous — Wed, 23 Sep 2020 20:11:59 GMT

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

But thank u for responding!