cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Fiala
Frequent Visitor

number of repeating values until xy days

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

AA1.1.20 6:541
b3.1.20 14:480
c8.1.20 9:460
d15.1.20 20:010
e20.1.20 10:500
AA1.1.20 8:000
AA15.1.20 10:000
3 REPLIES 3
amitchandak
Super User IV
Super User IV

@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...



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Fiala
Frequent Visitor

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
Super User III
Super User III

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





If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors