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