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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
drogzy
Helper I
Helper I

Measure to pull column A only when date (column B) is max, min or med

Hi all, 

 

Here is what I have: 

 

Table 1: 

 

IDDate Started Action 
1002003002021-03-12 5:00 PMInstall
1002003002021-03-10 3:00PMOpen Hole
1002003002021-03-14 6:30 AMAbandon

 

I want to create a measure to pull a specific 'Action' row based on the date being max, min or in between (med). 

 

Thanks

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

Hi @drogzy 

you slice by date and use simple 

MAX, MIN, AVERAGE to get the desired date

 

In order to get the Action for example

Action of Min. Date =

CALCULATE ( 

SELECTEDVALUE ( TableName[Action] ), 

TableName[Date Sarted] = MIN ( TableName[Date Sarted] ) 

)

 

View solution in original post

1 REPLY 1
tamerj1
Super User
Super User

Hi @drogzy 

you slice by date and use simple 

MAX, MIN, AVERAGE to get the desired date

 

In order to get the Action for example

Action of Min. Date =

CALCULATE ( 

SELECTEDVALUE ( TableName[Action] ), 

TableName[Date Sarted] = MIN ( TableName[Date Sarted] ) 

)

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors