How to get todays date on in filter for card

[hb0135]

Hello,
I am having data shown below in that daily i put some value datewise and i ahve installed gateways to to auto refresh the power Bi report but  to get todays date value in card i need manually add the todays date and then publish the report can we di this automatically or with help DAX measures.

Thanks

BR

hb0135

[Ritaf1983 · Accepted solution]

Hi @hb0135 
Yes, if I understood you correctly, you can filter the card by the "last date" data.
You can use DAX function last nonblank value:

value_ = LASTNONBLANKVALUE('Table'[Date],sum('Table'[value]))

pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[hb0135]

Hello,

Thanks for help

[Ritaf1983]

Happy to help 🙂