topic Re: How to FInd the MAX date for a particluar license number in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-FInd-the-MAX-date-for-a-particluar-license-number/m-p/3653514#M141546 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="620759" data-lia-user-login="Rkrama746" class="lia-mention lia-mention-user">Rkrama746</a>&nbsp;<BR /><BR />Create this measure and use it:</P> <LI-CODE lang="markup">_MsrMaxExpirationDate = CALCULATE ( MAX ( DimStaffLicenses[ExpirationDate] ), ALLEXCEPT ( DimStaffLicenses, DimStaffLicenses[LicenseNumber] ) )</LI-CODE> Tue, 23 Jan 2024 08:39:57 GMT Fowmy 2024-01-23T08:39:57Z How to FInd the MAX date for a particluar license number https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-FInd-the-MAX-date-for-a-particluar-license-number/m-p/3653449#M141542 <P>I am trying to find MAX date for a particular License number but i am not able to acheive this.</P><P>&nbsp;</P><P>Please find these for refrence</P><P><BR />_MsrMaxExpirationDate =<BR />MAXX(<BR />SUMMARIZE(<BR />DimStaffLicenses,<BR />DimStaffLicenses[LicenseNumber],<BR />"MaxExpirationDate", MAX(DimStaffLicenses[ExpirationDate])<BR />),<BR />[MaxExpirationDate]<BR />)</P><P>&nbsp;</P><P>But not getting MAX date with this condtion</P> Wed, 17 Apr 2024 14:13:19 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-FInd-the-MAX-date-for-a-particluar-license-number/m-p/3653449#M141542 Rkrama746 2024-04-17T14:13:19Z Re: How to FInd the MAX date for a particluar license number https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-FInd-the-MAX-date-for-a-particluar-license-number/m-p/3653514#M141546 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="620759" data-lia-user-login="Rkrama746" class="lia-mention lia-mention-user">Rkrama746</a>&nbsp;<BR /><BR />Create this measure and use it:</P> <LI-CODE lang="markup">_MsrMaxExpirationDate = CALCULATE ( MAX ( DimStaffLicenses[ExpirationDate] ), ALLEXCEPT ( DimStaffLicenses, DimStaffLicenses[LicenseNumber] ) )</LI-CODE> Tue, 23 Jan 2024 08:39:57 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-FInd-the-MAX-date-for-a-particluar-license-number/m-p/3653514#M141546 Fowmy 2024-01-23T08:39:57Z Re: How to FInd the MAX date for a particluar license number https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-FInd-the-MAX-date-for-a-particluar-license-number/m-p/3654208#M141578 <P>Thanks A lot</P> Tue, 23 Jan 2024 13:55:34 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-FInd-the-MAX-date-for-a-particluar-license-number/m-p/3654208#M141578 Rkrama 2024-01-23T13:55:34Z