Forum Discussion
Show the latest (by date) data on Card
Hi tspoon, I hope you are doing well,
There is no need to convert sold column to text, you can keep it to number. You have to create a DAX measure to achieve your requirement. Please create the below measure and then drag and drop it into the card visual
Sales on Latest Date =
CALCULATE(
SUM(Sales[Sold]),
Sales[Date] = MAX(Sales[Date])
)Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
Let's Connect on LinkedIn: https://www.linkedin.com/in/anmol-malviya/?originalSubdomain=in
Super UserHi tspoon, I hope you are doing well,
There is no need to convert sold column to text, you can keep it to number. You have to create a DAX measure to achieve your requirement. Please create the below measure and then drag and drop it into the card visual
Sales on Latest Date =
CALCULATE(
SUM(Sales[Sold]),
Sales[Date] = MAX(Sales[Date])
)
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
Let's Connect on LinkedIn: https://www.linkedin.com/in/anmol-malviya/?originalSubdomain=in
Dear anmolmalviya05
Thank's a lot for your help.
I use these as my actual table have lots of data:
Sales on Latest Date =
CALCULATE(
MAX(Sales[Sold]),
Sales[Date] = MAX(Sales[Date])
)
