Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi all,
Could you please help with the below? I used this technique many times with integers,which worked fine, but it doesn't work when doing distinct count on text. I need to get cumulative total of customers for 3 different date columns. Sales table data is in the comment below.
Data model:
I need to create identical measures for all 3 date columns, therefore using the inactive relationships.
Solved! Go to Solution.
I worked it out! 😄
data:
Customer ID | Sofa sales | TV sales | Chair sales |
1 | 01/01/2021 | 02/03/2021 | 06/03/2021 |
2 | 30/12/2020 | 14/03/2021 | 16/04/2021 |
3 | 16/12/2020 | 01/01/2021 | 16/05/2021 |
4 | 03/02/2021 | 15/06/2021 | |
5 | 26/02/2021 | ||
6 | 13/12/2020 | 18/02/2021 | |
7 | 16/01/2021 | 24/02/2021 | 30/03/2021 |
8 | 02/04/2021 | 28/05/2021 | |
9 | 03/01/2021 | 26/01/2021 | |
10 | 26/04/2021 | ||
11 | 18/02/2021 | 28/05/2021 | |
12 | 13/12/2020 | ||
13 | 26/02/2021 | 28/05/2021 | 03/06/2021 |
14 | 28/05/2021 | 15/06/2021 | |
15 | 13/12/2020 | ||
16 | 18/02/2021 | 14/03/2021 | 20/05/2021 |
17 | 13/12/2020 | ||
18 | 13/12/2020 | 15/06/2021 | |
19 | 15/06/2021 | ||
20 | 13/12/2020 | ||
21 | 16/12/2020 | 14/03/2021 | |
22 | 15/06/2021 | ||
23 | 13/12/2020 |
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
87 | |
86 | |
75 | |
69 | |
66 |
User | Count |
---|---|
216 | |
128 | |
117 | |
82 | |
76 |