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...
here for example I have 3 faults
I thought a lot how to do it in dax but it blow my mind.... any solutions?
@radissoufan how come C is red, it doesn't have next 2 days with same value?
Proud to be a Datanaut! Appreciate your Kudos Feel free to email me with any of your BI needs.
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
@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.
I think you got the idea...
"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
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.