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,
I have daily customer data in that if value continuously 7 then consider as 1 please find below example kindly help me.
Date | Customer ID | Value |
01/10/2023 | 11100 | 7 |
02/10/2023 | 11100 | 7 |
03/10/2023 | 11100 | 7 |
04/10/2023 | 11100 | 7 |
05/10/2023 | 11100 | 7 |
08/10/2023 | 11100 | 7 |
09/10/2023 | 11100 | 0 |
10/10/2023 | 11100 | 0 |
11/10/2023 | 11100 | 0 |
12/10/2023 | 11100 | 0 |
15/10/2023 | 11100 | 0 |
16/10/2023 | 11100 | 0 |
17/10/2023 | 11100 | 0 |
18/10/2023 | 11100 | 0 |
19/10/2023 | 11100 | 7 |
23/10/2023 | 11100 | 7 |
24/10/2023 | 11100 | 7 |
25/10/2023 | 11100 | 7 |
26/10/2023 | 11100 | 7 |
29/10/2023 | 11100 | 0 |
30/10/2023 | 11100 | 0 |
31/10/2023 | 11100 | 0 |
01/10/2023 | 111002 | 7 |
02/10/2023 | 111002 | 7 |
17/10/2023 | 111002 | 7 |
18/10/2023 | 111002 | 7 |
19/10/2023 | 111002 | 0 |
23/10/2023 | 111002 | 0 |
24/10/2023 | 111002 | 7 |
25/10/2023 | 111002 | 0 |
now expected result like both customer values should be : (lets say first customer have continuous 7 values 2 times so result is 2 , and second customer have only one time continuous 7 value hence result will be 1.)
Customer ID | Result |
11100 | 2 |
111002 | 1 |
Hi @Ahmedx ,
Thanks for your effort.
I have created column same DAX but shoing error where as "OFFSET, ORDERBY, PARTITIONBY" not valid function.
FYI
the minimum not interruption is what should it be: 4 or 3 or 2?
Hi @Ahmedx ,
daily datewise If continuous value 7 then need to consider result as 1 please refer below result.
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 | |
84 | |
67 | |
63 | |
63 |
User | Count |
---|---|
208 | |
120 | |
113 | |
79 | |
72 |