Latest of certain meeting type per client

[Mark_Adams]

Hello. I have seen similar queries but can't match them to this problem.

I have clients who have each had several meetings of different meeting types. I need a table that shows the most recent Core Meeting for each client please. So I wish to discard all of the other meeting types and then show just the most recent of the Core Meetings.

This is a sample of my unfiltered list:

This is what I want to see

TIA

[some_bih]

Hi @Mark_Adams I noticed that I create queary, please find measure below

Measure test 2= MAX(YourTable[Date of Meeting])

Adjust your table name.

[Dangar332]

Hi  @Mark_Adams 

i am take same data you provide 

make a new measure 

result = CALCULATE( MAX('Table'[date of meeting]),'Table'[type]="core meeting")

put client code , type , result in table you get your answer 

Did i answer your question? Mark my post as a solution which help other people to find  fast and easily.

[some_bih]

Hi @Mark_Adams 

Measure test =
SUMMARIZECOLUMNS(YourTable[Client Code],YourTable[Type], "@Max Date of Meeting", MAX(YourTable[Date of Meeting])
)

Adjust your table name

Did I answer your question? Kudos appreciated / accept solution!

[Mark_Adams]

I'm afraid I'm getting errors. I'm going to amend my SQL for the dataset and just use filters. thanks for your help