https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Overlap-Analysis/m-p/1167671#M17950 <P>Thank you so much. It Worked. <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Thu, 18 Jun 2020 05:15:49 GMT Anonymous 2020-06-18T05:15:49Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Overlap-Analysis/m-p/1164724#M17875 <P>Hi, I am working on an overlap analysis and need help on that. Actually I want to create a matrix in which I want to show the number of customers who were in segment "A" previous year and changed to segment "B","C","D" or "E" this year. Can anyone please help on this? I have attached the screenshot of the matrix which I need. I have two columns in my table with previous year segment and current year segment.</P><P><img /></P> Wed, 17 Jun 2020 04:02:44 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Overlap-Analysis/m-p/1164724#M17875 Anonymous 2020-06-17T04:02:44Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Overlap-Analysis/m-p/1167037#M17930 <P>What have you tried?&nbsp; Try this: Take a matrix, add current year to rows, previous year to columns, and any other column (summarized as count) for the values.</P> Wed, 17 Jun 2020 20:05:08 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Overlap-Analysis/m-p/1167037#M17930 lbendlin 2020-06-17T20:05:08Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Overlap-Analysis/m-p/1167671#M17950 <P>Thank you so much. It Worked. <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Thu, 18 Jun 2020 05:15:49 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Overlap-Analysis/m-p/1167671#M17950 Anonymous 2020-06-18T05:15:49Z