Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 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 i...
Visual
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , Hop you have Date not month

Try like

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

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

     

    But thank u for responding!