topic Re: Latest of certain meeting type per client in DAX Commands and Tips

Latest of certain meeting type per client

Mark_Adams — Wed, 27 Sep 2023 14:20:37 GMT

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

Re: Latest of certain meeting type per client

some_bih — Thu, 28 Sep 2023 06:43:27 GMT

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!

Re: Latest of certain meeting type per client

Mark_Adams — Thu, 28 Sep 2023 09:15:52 GMT

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

Re: Latest of certain meeting type per client

Dangar332 — Thu, 28 Sep 2023 10:15:45 GMT

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.

Re: Latest of certain meeting type per client

some_bih — Thu, 28 Sep 2023 10:15:48 GMT

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.