Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Latest date value in Card visual

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-

DateIT
Jan1
Feb2
March3

 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 !

Visual

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , Hop you have Date not month

    Try like

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

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

       

      But thank u for responding!