Forum Discussion
Hello All,
I need assitance in writing a DAX for this purpose.
Table structure:
1. country, customer code, channel, date, sales value.
2. Date table.
Task: I want to show the count of customers that has sales in a selected month, their sales value and average value per customer. At the sametime, be able to show these metrics for the next 12 month after the selected month (MoM) for only the customers that has sales in the selected month.
Your support would be appreciated and available for any further clarification. Anonymous arvindsingh802
9 Replies
- lbendlin
Super User
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523That's the kind of the result I want to achieve... By analyzing subsequent sales of group of customer that has sales in the first month selected.
Customer Code Grouped Products Type of Outlet Distributor Regions Channel Segment Brand Carton value Date 28891407 Group 1 Type 1 Region 1 Canal 1 Segment 1 Brand 1 0 8 07/04/2022 28891407 Group 2 Type 1 Region 1 Canal 1 Segment 1 Brand 1 0 8 16/05/2022 28891737 Group 1 Type 1 Region 1 Canal 1 Segment 1 Brand 1 0 3 06/06/2022 28891737 Group 2 Type 1 Region 1 Canal 1 Segment 1 Brand 1 0 3 21/12/2022 28891744 Group 2 Type 1 Region 1 Canal 1 Segment 1 Brand 1 1 33 29/04/2022 28891876 Group 3 Type 2 Region 1 Canal 1 Segment 2 Brand 1 0 3 23/10/2022 28891900 Group 2 Type 2 Region 1 Canal 1 Segment 1 Brand 1 0 1 24/09/2022 28891901 Group 1 Type 1 Region 1 Canal 1 Segment 1 Brand 1 0 1 30/04/2022 28891901 Group 2 Type 1 Region 1 Canal 1 Segment 1 Brand 1 0 1 28/09/2022 - talespin
Solution Sage
Re: DAX - Microsoft Fabric Community
I would apreciate it if guide me through this task. I don't knopw how am going to share pbix file here.- lbendlin
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
