DAX

[Oluwatosin_12]

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. @Sandra_ @arvindsingh802 

[talespin]

hi @Oluwatosin_12 

Please share pbix file with mock data or table with data.

[Oluwatosin_12]

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-...

[Oluwatosin_12]

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

[lbendlin]

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-...

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/1447...

[Oluwatosin_12]

[Oluwatosin_12]

That'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.

[lbendlin]

Sounds good.  What have you tried and where are you stuck?

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-...

[Oluwatosin_12]

I am stuck at the getting the right measure to achieve this aim. I have uploaded the data to my Power BI, created a date table and established relationship successfully. I need help with the right measure. Thanks