Show only lastest value based on last date and status

[Anonymous]

Hi, 

I have/created this table: 

I want to show only the lastest value for each pipeline.

For example, in that example I just wanted to show the status "Succeeded" for pipeline1 and the status "Failed" for pipeline2. If the pipeline has not yet finished and it is inProgress it would only show the status InProgress (in this case it would be the last case to be shown because it wouldn't have the End Date yet)

How to achieve the desired result?
Thanks for your helps.

[NikhilChenna]

Hi @Anonymous , i think this the solution

1. Create a summarize table using new table in Power BI, click on the modelling tab and click on the new table option.

Summarize_table =

SUMMARIZE(

    'table1',

    'table1'[PipelineName],

    "MAXendDate",MAX('table1'[End Date]),

    "MAXStatus",MAX('table1',[status]

)

After creating this you can drag fields from this table and you'll get your output.

Regards,

Nikhil Chenna

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

[Anonymous]

Hi @NikhilChenna thanks for your answer ! 😊

I had already tested this approach too and unfortunately it wasn't giving me the intended result:

Once again thanks a lot and kind regards !

[NikhilChenna]

Hi @Anonymous ,

In that case what you can do is, 

1. Create another calculated column in the summarized table. 

2. Column =

IF('Maintable'[EndDate]<>Blank(),

LOOKUPVALUE( 'Maintable' [Status], 'Maintable'[Pipeline], 'Summarizedtable'[Pipeline])

)

Regards,

Nikhil Chenna

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

[Anonymous · Accepted solution]

Hi @NikhilChenna ,

I solved my problem with just one measure:

End T =
MAXX (
    SUMMARIZE (
        'EDH PRO Monitor',
        'EDH PRO Monitor'[Duration],
        'EDH PRO Monitor'[Status],
        'EDH PRO Monitor'[PipelineName]
    ),
    MAX ( 'EDH PRO Monitor'[End] )
)

Output:

but thanks a lot for your suggestions and answers👍,

Kind regards. 

[teste11234]

How can I do to count the rows?