LASTDATE FILTER

GiuseppeTE ,

I am sorry. I thought you wanted a measure that would give you 1 value to use in a visual. Upon rereading this, I see that you are really looking for a column. There may be a better way to do this and I am sure that you can consolidate this, but I have run out of time. So, I created some columns mostly with if statements and added them to the table. It is not pretty, but I believe it works.

I added 4 columns which as I said you can probably consolidate:

selected_last_date = LASTDATE(ALL(Cycles[shift_date]))

 

selected_last_shift = IF(Cycles[status] =200 && Cycles[shift_date]=Cycles[selected_last_date],(Cycles[shift_no]))

 

last_actual_cycle_time = (IF(Cycles[status] =200 && Cycles[shift_date]=LASTDATE(ALL(Cycles[shift_date])) && (Cycles[shift_no])= MAX (Cycles[selected_last_shift]), Cycles[actual_cycle_time]))

 

cycleactuallast = MAX(Cycles[last_actual_cycle_time])

 

As I said I was working on putting this into one column, but ran out of time, so there may be some duplication, but with these columns it works.

 

For a single measure that you can display in a card, I have this:

FINAL = VAR Maxdate = MAX(Cycles[shift_date])

VAR Maxnumber = CALCULATE(MAX(Cycles[shift_no]),Cycles[shift_date]=Maxdate)

Var Maxstatus = 200

return Calculate(MAX(Cycles[actual_cycle_time]),Cycles[shift_date]=Maxdate,Cycles[status]=Maxstatus,Cycles[shift_no]=Maxnumber)

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel