Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Could anyone help to get the measure to work like ==IF(COUNTIFS([Value];B3;[Date];"<"&C3+3;[Date];">="&C3)=1;0;1)
ValueDateRepated unil 3 Days
AA | 1.1.20 6:54 | 1 |
b | 3.1.20 14:48 | 0 |
c | 8.1.20 9:46 | 0 |
d | 15.1.20 20:01 | 0 |
e | 20.1.20 10:50 | 0 |
AA | 1.1.20 8:00 | 0 |
AA | 15.1.20 10:00 | 0 |
@Fiala , Data you have shared not making the problem clear.
I have a blog on Continuous Streak, see if that can help
Hi Pragati11,
I need to find out if the value was repeated within 3 days of its first occurrence. For example, the value is the ticket number and the date represents the date the ticket was created. The number one in the table represents the desired result. The "AA" value was repeated within 3 days. All data is in one table. Ideally, it would be possible to change the number of days.
Hi @Fiala ,
Can you explain please what your excel formual is doing?
Specially the highlighted portion:
IF(COUNTIFS([Value];B3;[Date];"<"&C3+3;[Date];">="&C3)=1;0;1)
From where are these variables coming and what logic you are trying to implement here as I am not able to replicate this excel formual at my end?
Thanks,
Pragati
User | Count |
---|---|
42 | |
28 | |
23 | |
18 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |