Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |