Forum Discussion
Solved
Create multi row card with latest date and text value
Hello, I would like to create an "indicator" card that shows the latest date and text value (either "Criteria Met" or "Criteria Not Met") for the country selected in the slicer on the page. Many...
Thank you all! Yes, the filter was the issue. I was able to come to a solution with the following code:
most recent testing criteria = VAR Most_recent_date_testing = [Most recent date testing]
RETURN
CALCULATE(MAX([who_criteria_testing_last]), FILTER(ALL('who_criteria (2)'), 'who_criteria (2)'[Date] = Most_recent_date_testing))
amitchandak
Super User
Super Userjg84 , Not very clear
max(Table[date]) or lastnonblank(Table[date], blank()) should give you that ?