Find the last job by date

[vbourbeau]

Hi look the below image it's what I'm looking to do :

at the left it's the table and at the right the graph. The graph must be only the last job, here it's job B since it's today (in the real table I have also minutte so no duplication date possible)

For this example I hard code the job number on the page filter but in real live I want it dynamic.

here the source: https://we.tl/t-4PI5U5MJxC

[Greg_Deckler]

@vbourbeau This is essentially Lookup Min/Max - https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/m-p/985814#M434

In your case:

Measure = 
  VAR __MaxDate = MAX('Table',[date])
RETURN
  MAXX(FILTER('Table',[date]=__MaxDate),[value])

[vbourbeau]

We are close but I think we need to link with the JOB number.

Here a put another example with time and more cycle for the JOB "C". Look the cycle 4 is add but JOB "B" don't have 4 cycle.

code: https://we.tl/t-c3d78EnaA7

[dedelman_clng · Accepted solution]

Hello @vbourbeau - you can try this

Create a Measure The Last Work

Last Job =
CALCULATE (
    LASTNONBLANKVALUE ( Jobs[date], MAX ( Jobs[Job] ) ),
    ALL ( Jobs[Job] )
)

Create an IsLastJob measure

IsLastJob =
IF ( SELECTEDVALUE ( Jobs[Job] ) = [Last Job], 1, 0 )

Create the chart with Cycle as an X axis, Value as y-axis, and Work as legend. Next, add IsLastJob in the visual filters and set it to 1 (it's 1).

I hope this helps

David