Difficulty in customer analysis

Anonymous — Sun, 26 Nov 2023 17:16:23 GMT

I'm finding difficulty in doing a customer analysis with the data presented to me. I have the following data presented in one sheet.

Date, Customer Code, Customer Name, Net Sales, Qty, Profit, Item Name, Item Code,Branch Name , Category , Sub Category, Department

I'm unable to get accurate calculations in PowerBI whilst finding new customers, lost customers, and repeating customers. For eg. The data is for this year and last year, and I have obtained the no.of new customers and put it on a table. However, when I export it to Excel the number of new customers is even more. Would it be better to separate the data into separate tables and import it to Power BI?

This is how I would define the new, lost, and repeating as I have created a dynamic slicer of (net qty / sales / profit) so I would like to see new/lost/customer by those values

New Customers - Count Customers who made their first purchase

Lost Customers - Count Customers not present this year

Repeating Customers - Count Customers present in both years

Re: Difficulty in customer analysis

FreemanZ — Mon, 27 Nov 2023 01:28:46 GMT

hi Anonymous ,

your case is very similar to:

https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-formula-for-datetimeline/m-p/3551189

topic Difficulty in customer analysis in DAX Commands and Tips

Difficulty in customer analysis

Re: Difficulty in customer analysis