I want to get a value 'BuildNumber' on charts based on latest execution date.

[arvindsj]

I need to publish latest value in 'BuildNumber' column based on latest date in "Exec_Time' column.  There are multiples build number in the column, I need to get build number based on latest execution date. I have pasted snap shot of table below. Any help how to get this done..!!

[v-luwang-msft · Accepted solution]

Hi @arvindsj ，

You could use the following measure,wish it is helpful for you!

Measure =
VAR lastexec_time =
    CALCULATE ( MAX ( 'Table'[Exec_time] ), ALL ( 'Table' ) )
VAR build =
    CALCULATE (
        MAX ( 'Table'[BuildNumber] ),
        FILTER ( ALL ( 'Table' ), 'Table'[Exec_time] = lastexec_time )
    )
RETURN
    build

base data:

after:

Best Regards

Lucien

[arvindsj]

@v-luwang-msft - thanks for your suggestion. This solution worked for me. 

[Jihwan_Kim]

Hi, @arvindsj 

Please correct me if I am wrong, but I assume the last date in Exectime column is based on the testID?

Then, please try the below.

if it is not working, please kindly share the sample pbix file. Then, I can try to come up with a more accurate measure. The data in the above picture looks all the same except the RUNID.

Latest Buildnumber =

VAR maxtime =

CALCULATE (

MAXX (

'Table',

'Table'[Exec_Time]

),

ALLSELECTED ( 'Table' ),

VALUES ( 'Table'[TestID] )

)

RETURN

CALCULATE (

SELECTEDVALUE ( 'Table'[BuildNumber] ),

'Table'[Exec_Time] = maxtime

)

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster.