cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
radissoufan Regular Visitor
Regular Visitor

how to find repeated values for same value column but next dates

hello

I have multiple factories that I want to monitor thier production by time...

if the production between 2 next dates for a factory remain the same then this factory has something wrong...

factorydate and hourproduction
A21/09/2019 10:00100
A21/09/2019 12:01100
A22/09/2019 13:02100
A22/09/2019 20:03200
B21/09/2019 10:04200
B21/09/2019 10:05300
C21/09/2019 10:06400
C21/09/2019 10:07400

here for example I have 3 faults

I thought a lot how to do it in dax but it blow my mind.... any solutions?

5 REPLIES 5
Super User
Super User

Re: how to find repeated values for same value column but next dates

@radissoufan how come C is red, it doesn't have next 2 days with same value?






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





radissoufan Regular Visitor
Regular Visitor

Re: how to find repeated values for same value column but next dates

hello @parry2k 

Thank you for replay and sorry if I didnt gaive a right image for you

but let me clearfy a point you said: 2 days

the bussniss say 2 dates e.g. 2 days, 2 months, 2 hours

any next 2 dates for same factory

 

and about c>> it has 400 for both 10:06 and 10:07

 

t.png

 

Super User
Super User

Re: how to find repeated values for same value column but next dates

@radissoufan I'm still not sure when you say "Next" two days.

 

I think you mean two transactions including current, regardless of date/time. It is safe to say if production value is same as previous transaction of same factory then make it red.

 

For me "Next" mean, current transaction and 2 next transactions. May be I'm missing something here.






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





radissoufan Regular Visitor
Regular Visitor

Re: how to find repeated values for same value column but next dates

@parry2k 

I think you got the idea...

but 

"I think you mean two transactions including current" YES

"regardless of date/time" NOT 100% true, because the date/time is the unit that I will use to sort the values to know which value is current and which is next

 

radissoufan Regular Visitor
Regular Visitor

Re: how to find repeated values for same value column but next dates

No answers??

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 31 members 769 guests
Please welcome our newest community members: