Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Mark_Adams
Frequent Visitor

Latest of certain meeting type per client

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:

 

Mark_Adams_0-1695824177282.png

This is what I want to see

 

Mark_Adams_2-1695824268515.png

TIA

 

 

4 REPLIES 4
some_bih
Super User
Super User

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.

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Dangar332
Super User
Super User

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 
Dangar332_0-1695896067904.png

 

 

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

some_bih
Super User
Super User

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!





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors