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

[drogzy]

Hi all, 

Here is what I have: 

Table 1: 

ID	Date Started	Action
100200300	2021-03-12 5:00 PM	Install
100200300	2021-03-10 3:00PM	Open Hole
100200300	2021-03-14 6:30 AM	Abandon

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

Thanks

[tamerj1 · Accepted solution]

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] ) 

)