I finally got one right! -slighlty different to yours - but just compared if requireded date = shipped date Var Ordertable =SUMMARIZE( Orders,Orders[RequiredDate],Orders[ShippedDate], "On Time",[RequiredDate]=[ShippedDate]) Return countrows(filter(Ordertable,[On Time]))
@CurbalEN24 күн бұрын
🥳🥳🥳 It is only going to get better and better!
@HachiAdachi24 күн бұрын
oooh, having a bad streak all due to my lack of attention to detail... Forgot to check the glossary for the meaning of "on time orders" this time... ... ok, time to regroup and get my groove back! 💪
@CurbalEN24 күн бұрын
You can do this!!
@Henrik.Vestergaard23 күн бұрын
meetoo :o)
@CurbalEN23 күн бұрын
On no! :(
@joefromdc24 күн бұрын
Thanks for the video. Feedback - DAX Query ( evaluate.) within power bi, in my opinion is similar to writing a SQL statement. I see the majority of ppl using power query, then filter on normal table to get the answer.
@Wozzuup24 күн бұрын
For these different questions, can you also suggest a simpler solution that the one that tries to reproduce a visual table with the "SUMMARIZE" function ? Example for this one, a simple COUNTROWS and a FILTER Ship date = Request date
@CurbalEN24 күн бұрын
I am just trying to show a method that works very often for those that struggle with DAX. Hope it makes sense
@rajeevmenon197516 күн бұрын
Can we use a strict equal (==) and get the desired result ?
@emanueledelzoppo516424 күн бұрын
Hello! Is it the same to use calculatetable instead of filter?
@CurbalEN24 күн бұрын
No, they are different!
@tinaflemons26324 күн бұрын
It seems that if shipped before, it should also be on time because it is not late.
@CurbalEN24 күн бұрын
Too early is not good either in certain businesses
24 күн бұрын
anyway, it was described on the glossary :P
@martyc567424 күн бұрын
@@CurbalEN yes- this is my business- we want nothing too early- when something arrives we have 60 days to pay. We want everything just in time. (Which is a PITA!)
@tinaflemons26324 күн бұрын
@CurbalEN understood thank you for the feedback. Keep up the fantastic work
@edscreations755224 күн бұрын
Interpreting the question is malware 😂 I saw "Orders delivered on the day requested" as Orders delivered on the day they are ordered🤦
@CurbalEN24 күн бұрын
😂😂😂 sorrry!!
@pablogenero167824 күн бұрын
Oh, it is only with orders shipped on the same day. I also counted the orders shipped before the requested date 🥲