cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper V

Determine maximum row of database

Hi,

I have the following table. Machine status color is a calculated column. Now I need only the first row of the table to be displayed, which is the maximum of the end time. How can I achieve this? Problem is integrating measure into a calculated column. Please reply a.s.a.p. Thanks in advance!

9 REPLIES 9
Community Support

You could probably try the RANKX function.

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
Helper V

Hi, I do not get the required results with above mentioned solutions. To be more specific: I need a table which represents the latest end time and machine status per machine ID. How can I achieve this?

Impactful Individual

Hi,

I think this will help ?

```LastStatus =
MAXX(
SUMMARIZE('Table';'Table'[ID]; "mx"; MAX('Table'[End time]));
MAX('Table'[Status]))```
Super User

What will be the final output?

According to my understanding,

This is the what you need.

If not, Please provide a sample output.

Helper V

Hi,

Thanks for your feedback. I don't get the correct result with the summarize function but formula with '
Calculate(lastnonblank) works partly. Then I get the underlying table.  When I put the color into the table, the lastnonblank for every color is presented. This is not what I need. I need one color of the last non blank. See printscreen as an example.  I have 8 machines so I need the 8 rows which presents the machine ID, the last non blank date/time and the related color. For machine ID 1 this is the color Red, for machine ID 2 color Red, for machine ID 3 color orange, etc... Thanks for support in advance.

Super User

Hi,

The first row in your image is not the max of the End time.  Infact it is the minimum.  I am not clear with your end result.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Impactful Individual

Hi there,

You could just filter your visual like this:

hope this helps ?

Helper V
Table is empty after this action! Alternative solution???
Impactful Individual

Add a filter, is not blank ?

Announcements

Fabric certifications survey

Certification feedback opportunity for the community.

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors