D8: Orders delivered on time |

Рет қаралды 873

Күн бұрын

Пікірлер: 24

@martyc5674 Ай бұрын

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]))

@CurbalEN Ай бұрын

🥳🥳🥳 It is only going to get better and better!

@HachiAdachi Ай бұрын

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! 💪

@CurbalEN Ай бұрын

You can do this!!

@Henrik.Vestergaard Ай бұрын

meetoo :o)

@CurbalEN Ай бұрын

On no! :(

@rajeevmenon1975 Ай бұрын

Can we use a strict equal (==) and get the desired result ?

@joefromdc Ай бұрын

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.

@tinaflemons263 Ай бұрын

It seems that if shipped before, it should also be on time because it is not late.

@CurbalEN Ай бұрын

Too early is not good either in certain businesses

Ай бұрын

anyway, it was described on the glossary :P

@martyc5674 Ай бұрын

@@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!)

@tinaflemons263 Ай бұрын

@CurbalEN understood thank you for the feedback. Keep up the fantastic work

@Wozzuup Ай бұрын

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

@CurbalEN Ай бұрын

I am just trying to show a method that works very often for those that struggle with DAX. Hope it makes sense