Determine maximum row of database

Question

Hi,&nbsp;I have the following table. Machine status color is a calculated column. Now I need only&nbsp;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!&nbsp;

robbevl · Answer

Hi there,&nbsp;You could just filter your visual like this:&nbsp;&nbsp;hope this helps ?

anonymous · Answer

Table is empty after this action! Alternative solution???

robbevl · Answer

Add a filter, is not blank ?&nbsp;

ashish_mathur · Answer

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

v-diye-msft · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
You could probably try the RANKX function.
&nbsp;

Forum Discussion

Determine maximum row of database

9 Replies

Related content

Running Maximum

Database connectivity.

Fabric Capacity Determination

Database exceeds the maximum size limit on disk

Rows - Maximum Date