Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
Hi @coding , 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.
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 !
Hi @coding ,
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!
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.
How can I do to count the rows?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |