topic Re: DAX in DAX Commands and Tips

DAX

Oluwatosin_12 — Wed, 20 Mar 2024 14:25:59 GMT

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

Re: DAX

lbendlin — Wed, 20 Mar 2024 22:15:05 GMT

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/1447523

Re: DAX

Oluwatosin_12 — Sat, 23 Mar 2024 22:52:25 GMT

Re: DAX

Oluwatosin_12 — Sat, 23 Mar 2024 22:54:00 GMT

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.

Re: DAX

lbendlin — Sat, 23 Mar 2024 22:58:23 GMT

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

Re: DAX

Oluwatosin_12 — Sat, 23 Mar 2024 23:02:08 GMT

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

Re: DAX

Oluwatosin_12 — Sat, 23 Mar 2024 23:34:12 GMT

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

Re: DAX

talespin — Sun, 24 Mar 2024 06:07:01 GMT

hi Oluwatosin_12

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

Re: DAX

Oluwatosin_12 — Mon, 25 Mar 2024 07:51:31 GMT

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.

Re: DAX

lbendlin — Mon, 25 Mar 2024 12:56:28 GMT

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