https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/YoY-Lost-New-or-Existing-Customers/m-p/3754221#M146469 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="234199" data-lia-user-login="krkumar2" class="lia-mention lia-mention-user">krkumar2</a>&nbsp;,</P> <P>Thanks <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="100342" data-lia-user-login="lbendlin" class="lia-mention lia-mention-user">lbendlin</a>‘s quick reply and helpful links. Have you solved the problem and if so can you mark the helpful reply as a solution. If not resolved, can you provide your data in a usable format that will help us better understand and resolve the issue you are experiencing.</P> <P>&nbsp;</P> <P><A href="https://community.fabric.microsoft.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490" target="_blank" rel="noopener">How to Get Your Question Answered Quickly - Microsoft Fabric Community</A></P> <P>If it does not help, please provide more details with your desired out put and pbix file without privacy information.</P> <P>&nbsp;</P> <P>Best Regards,</P> <P>Ada Wang</P> Mon, 11 Mar 2024 07:14:48 GMT Anonymous 2024-03-11T07:14:48Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/YoY-Lost-New-or-Existing-Customers/m-p/3744574#M146031 <P><img /></P><P>&nbsp;</P><P>Sample data</P><P><img /></P><P>&nbsp;</P><P>Wrong Result&nbsp;</P><P><img /></P><P>&nbsp;</P><P>Expected Result&nbsp;</P><P><img /></P><P>&nbsp;</P> Wed, 06 Mar 2024 02:13:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/YoY-Lost-New-or-Existing-Customers/m-p/3744574#M146031 krkumar2 2024-03-06T02:13:23Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/YoY-Lost-New-or-Existing-Customers/m-p/3746364#M146110 <P><A href="https://www.sqlbi.com/blog/marco/2014/06/26/calculate-new-returning-lost-and-recovered-customers-in-dax/" target="_blank">Calculate New, Returning, Lost, and Recovered Customers in #dax - SQLBI</A></P> Wed, 06 Mar 2024 14:23:59 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/YoY-Lost-New-or-Existing-Customers/m-p/3746364#M146110 lbendlin 2024-03-06T14:23:59Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/YoY-Lost-New-or-Existing-Customers/m-p/3754221#M146469 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="234199" data-lia-user-login="krkumar2" class="lia-mention lia-mention-user">krkumar2</a>&nbsp;,</P> <P>Thanks <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="100342" data-lia-user-login="lbendlin" class="lia-mention lia-mention-user">lbendlin</a>‘s quick reply and helpful links. Have you solved the problem and if so can you mark the helpful reply as a solution. If not resolved, can you provide your data in a usable format that will help us better understand and resolve the issue you are experiencing.</P> <P>&nbsp;</P> <P><A href="https://community.fabric.microsoft.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490" target="_blank" rel="noopener">How to Get Your Question Answered Quickly - Microsoft Fabric Community</A></P> <P>If it does not help, please provide more details with your desired out put and pbix file without privacy information.</P> <P>&nbsp;</P> <P>Best Regards,</P> <P>Ada Wang</P> Mon, 11 Mar 2024 07:14:48 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/YoY-Lost-New-or-Existing-Customers/m-p/3754221#M146469 Anonymous 2024-03-11T07:14:48Z