YoY - Lost , New or Existing Customers

[krkumar2]

Sample data

Wrong Result 

Expected Result 

[v-yifanw-msft]

Hi @krkumar2 ,

Thanks @lbendlin‘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.

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang

[lbendlin]

Calculate New, Returning, Lost, and Recovered Customers in #dax - SQLBI