topic Re: Count ex-members (TIN) based on MembershipEndDate in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Count-ex-members-TIN-based-on-MembershipEndDate/m-p/3421219#M129519 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="613430" data-lia-user-login="tzaveri" class="lia-mention lia-mention-user">tzaveri</a>,</P> <P>Here is the measure formula that can get rolling 2 year records and get distinct member count, you can try it if it suitable for your requirement.</P> <LI-CODE lang="markup">formula = VAR currDate = MAX ( Table1[MembershipEndDate] ) RETURN CALCULATE ( COUNTROWS ( VALUES ( Table1[TIN] ) ), FILTER ( ALLSELECTED ( Table1 ), [MembershipEndDate] &gt;= DATE ( YEAR ( currDate ) - 2, MONTH ( currDate ), DAY ( currDate ) &amp;&amp; [MembershipEndDate] &lt;= currDate ) ) )</LI-CODE> <P>Regards,</P> <P>Xiaoxin Sheng</P> Fri, 08 Sep 2023 09:13:37 GMT Anonymous 2023-09-08T09:13:37Z Count ex-members (TIN) based on MembershipEndDate https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Count-ex-members-TIN-based-on-MembershipEndDate/m-p/3418390#M129374 <P>Looking to get count of ex-members (using their TIN in TIN column) from last 24 months based on MembershipEndDate.</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Wed, 06 Sep 2023 19:23:11 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Count-ex-members-TIN-based-on-MembershipEndDate/m-p/3418390#M129374 tzaveri 2023-09-06T19:23:11Z Re: Count ex-members (TIN) based on MembershipEndDate https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Count-ex-members-TIN-based-on-MembershipEndDate/m-p/3421219#M129519 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="613430" data-lia-user-login="tzaveri" class="lia-mention lia-mention-user">tzaveri</a>,</P> <P>Here is the measure formula that can get rolling 2 year records and get distinct member count, you can try it if it suitable for your requirement.</P> <LI-CODE lang="markup">formula = VAR currDate = MAX ( Table1[MembershipEndDate] ) RETURN CALCULATE ( COUNTROWS ( VALUES ( Table1[TIN] ) ), FILTER ( ALLSELECTED ( Table1 ), [MembershipEndDate] &gt;= DATE ( YEAR ( currDate ) - 2, MONTH ( currDate ), DAY ( currDate ) &amp;&amp; [MembershipEndDate] &lt;= currDate ) ) )</LI-CODE> <P>Regards,</P> <P>Xiaoxin Sheng</P> Fri, 08 Sep 2023 09:13:37 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Count-ex-members-TIN-based-on-MembershipEndDate/m-p/3421219#M129519 Anonymous 2023-09-08T09:13:37Z