topic Re: how to get values related to MIN or MAX in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-get-values-related-to-MIN-or-MAX/m-p/3989450#M154668 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="758858" data-lia-user-login="mark1" class="lia-mention lia-mention-user">mark1</a>&nbsp;<A href="https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/m-p/985814#M434" target="_blank">(1) Lookup Min/Max - Microsoft Fabric Community</A></P> Wed, 12 Jun 2024 19:10:47 GMT Greg_Deckler 2024-06-12T19:10:47Z how to get values related to MIN or MAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-get-values-related-to-MIN-or-MAX/m-p/3989399#M154662 <P>I'm hoping this is fairly simple but I've been unable to find any existing reference to my specific question...</P><P>&nbsp;</P><P>I understand how to use MIN or MAX to find the minimum or maximum value in a given column, but I'm not sure how to retrieve other values related to the MIN or MAX value.&nbsp;</P><P>&nbsp;</P><P>For example, given the dataset below, the MIN cost is 19.55. How can I create a measure that returns either the date (1/7/2020) or name (Harold) that are associated with this minimum cost value?</P><P>&nbsp;</P><P>Similarly, given the dataset below, the MAX cost is 21.92. This cost is associated with two different dates and names. How can I create a measure that lists the names assocuated with this maximum cost, or&nbsp;returns the earliest or latest date associated with this maximum cost?</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Date</TD><TD>Cost</TD><TD>Name</TD></TR><TR><TD>1/1/2020</TD><TD>20.12</TD><TD>David</TD></TR><TR><TD>1/2/2020</TD><TD>20.15</TD><TD>Susan</TD></TR><TR><TD>1/3/2020</TD><TD>20.18</TD><TD>Mike</TD></TR><TR><TD>1/4/2020</TD><TD>20.18</TD><TD>Paul</TD></TR><TR><TD>1/5/2020</TD><TD>20.18</TD><TD>John</TD></TR><TR><TD>1/6/2020</TD><TD>20.18</TD><TD>Mary</TD></TR><TR><TD>1/7/2020</TD><TD>19.55</TD><TD>Harold</TD></TR><TR><TD>1/8/2020</TD><TD>19.86</TD><TD>Ben</TD></TR><TR><TD>1/9/2020</TD><TD>19.82</TD><TD>Chris</TD></TR><TR><TD>1/10/2020</TD><TD>19.80</TD><TD>Julie</TD></TR><TR><TD>1/11/2020</TD><TD>19.70</TD><TD>Peter</TD></TR><TR><TD>1/12/2020</TD><TD>19.71</TD><TD>Henry</TD></TR><TR><TD>1/13/2020</TD><TD>19.98</TD><TD>Matt</TD></TR><TR><TD>1/14/2020</TD><TD>20.06</TD><TD>Jon</TD></TR><TR><TD>1/15/2020</TD><TD>20.09</TD><TD>Bret</TD></TR><TR><TD>1/16/2020</TD><TD>20.12</TD><TD>Byron</TD></TR><TR><TD>1/17/2020</TD><TD>20.20</TD><TD>Leah</TD></TR><TR><TD>1/18/2020</TD><TD>20.25</TD><TD>Oswald</TD></TR><TR><TD>1/19/2020</TD><TD>20.29</TD><TD>Jasmine</TD></TR><TR><TD>1/20/2020</TD><TD>21.50</TD><TD>Robert</TD></TR><TR><TD>1/21/2020</TD><TD>21.82</TD><TD>Donald</TD></TR><TR><TD>1/22/2020</TD><TD>21.11</TD><TD>Erik</TD></TR><TR><TD>1/23/2020</TD><TD>21.91</TD><TD>Richard</TD></TR><TR><TD>1/24/2020</TD><TD>21.92</TD><TD>Tammy</TD></TR><TR><TD>1/25/2020</TD><TD>21.92</TD><TD>Tia</TD></TR><TR><TD>1/26/2020</TD><TD>21.10</TD><TD>Greg</TD></TR><TR><TD>1/27/2020</TD><TD>20.65</TD><TD>Valerie</TD></TR><TR><TD>1/28/2020</TD><TD>20.62</TD><TD>William</TD></TR><TR><TD>1/29/2020</TD><TD>20.62</TD><TD>Kathy</TD></TR><TR><TD>1/30/2020</TD><TD>20.65</TD><TD>George</TD></TR><TR><TD>1/31/2020</TD><TD>20.66</TD><TD>Nathan</TD></TR></TBODY></TABLE><P>&nbsp;</P> Wed, 12 Jun 2024 18:58:12 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-get-values-related-to-MIN-or-MAX/m-p/3989399#M154662 mark1 2024-06-12T18:58:12Z Re: how to get values related to MIN or MAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-get-values-related-to-MIN-or-MAX/m-p/3989450#M154668 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="758858" data-lia-user-login="mark1" class="lia-mention lia-mention-user">mark1</a>&nbsp;<A href="https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/m-p/985814#M434" target="_blank">(1) Lookup Min/Max - Microsoft Fabric Community</A></P> Wed, 12 Jun 2024 19:10:47 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-get-values-related-to-MIN-or-MAX/m-p/3989450#M154668 Greg_Deckler 2024-06-12T19:10:47Z Re: how to get values related to MIN or MAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-get-values-related-to-MIN-or-MAX/m-p/3989609#M154685 <P><img /></P> Wed, 12 Jun 2024 21:37:25 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-get-values-related-to-MIN-or-MAX/m-p/3989609#M154685 ThxAlot 2024-06-12T21:37:25Z