Creating a Card that shows the most recent date and the corresponding item's name.

[RH10]

Hello everybody.

I am new to Power BI and am having trouble with creating a Card visual that displays more than one piece of information. My data is more complicated than this but the two tables below give a general idea of how my data is structured: I have 1 table with all of the courses and another table with each individual course session and the corresponding date. On the card, I want to show the most recent date and the corresponding item for that date.

CourseID	Course
c1	Biology
c2	Chemistry
c3	History
c4	Math
c5	Language

SessionID	Students	Date	CourseID
s1	16	2/20/2022 8:00 AM	c3
s2	20	2/22/2022 9:00 AM	c2
s3	24	2/21/2022 2:00 PM	c1
s4	30	2/19/2022 11:00 AM	c5
s5	14	2/20/2022 3:00 PM	c4

I want the card to look something like this:

I want to use a Card visual because I need it to update when the dates change. So if the date for session s1 becomes 2/23/2022 8:00 AM, then the Card will update to say "Most Recent Course History 2/23/2022 8:00 AM." From doing research on this site and elsewhere around the web, I gather that I need to create a Measure that can give this information and use that to create the Card visual. Please help me create this measure.

Thank you!

[lbendlin · Accepted solution]

"I want to use a Card visual because I need it to update when the dates change"

Not sure how this is related.

" I gather that I need to create a Measure "

Not really.  Measures are only required if you expect user interaction with your visuals. 

Attached is a simple implementation using a calculated column and RELATED.  The card will update whenever your dataset is refreshed.

[RH10]

Worked perfectly, thank you.