number of repeating values until xy days

[Fiala]

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

[amitchandak]

@Fiala , Data you have shared not making the problem clear.

I have a blog on Continuous Streak, see if that can help

https://community.powerbi.com/t5/Community-Blog/Power-BI-Continuous-Streak-With-One-Day-Break/ba-p/1...

[Fiala]

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.

[Pragati11]

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