Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Fiala
Helper II
Helper II

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

@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
Helper II
Helper II

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

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

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors