DAX Fridays!

[@christianlira1259]

A superb presentation of DATEDIFF and after searching for the solution, you provided it within 1 minute. Thank you

[@CurbalEN]

🥳🥳 /Ruth

[@Victor-ol1lo]

Ruth & Mike = Strong combo.... Thumbs Up!!!!

[@ayobamiologun9184]

Yeah! The two of them are just fantastic...

[@CurbalEN]

😊

[@jimmyni1983]

Hi Ruth! EXXXXXXCEELLENTTT "DAX Fridays" video! It makes my mind "WOWWWWW". Great job! 😍😍 👏👏

[@CurbalEN]

This trick is from ExcelIsFun, he is the magician 🎩 :) /Ruth

[@charliemather3368]

Nice video, Ruth! Another way to extract the minute from the time: Minute = VALUE(RIGHT(FORMAT(Data[IN_Time],"Short Time"),2))

[@CurbalEN]

Thanks for sharing and happy Friday! /Ruth

[@chronis69]

Ruth I do enjoy your videos and learn a lot from them. I understand the point of the videos is to teach function and stuff but the main point should be problem solving skills. In this video instead of going into all the made up trouble of identifing the times at mod 15 min, deducting by one and yada yada yada, the solution should have been.... Start charging penalties assuming the arrival time was 8.15 and beyond instead of 8.10 By the way the "opposite" function of mod is div. Mod returns the remainder of a division, div returns the times the divisor "fits" namely returning the integer part of the division result Keep up the good work

[@CurbalEN]

Hi! I always (almost) do my videos with a beginner user in mind. Those that are more advance users play the videos at 1.5 or 2 speed so the “slow “ parts are not too long. Maybe that will help you too. Thanks for the feedback:) /Ruth

[@brunof.s.8186]

Awesome! A few weeks ago i was struggling with those date-time format within some marathon times. this video brought so many possibilities, thank you!

[@CurbalEN]

Are you running a marathon? /Ruth

[@brunof.s.8186]

@@CurbalEN i did already, but i did not performed as i expected. i will try again next year. are you into running too? :)

[@CurbalEN]

I am actually tempted to run the Stockholm marathon next year. The longest I have run are only have marathons and it is itching... We’ll see... Which one are you running? /Ruth

[@brunof.s.8186]

@@CurbalEN wow! super cool! running is so addictive! i went for porto alegre marathon (south of brazil), and next year will probably attempt sao paulo's , in april. just pay the entrance fees in advance, don't think too much about it, and go crush that 42k! you have plenty of time to train accordinly. i'm eager to see your marathon report next year :)

[@CurbalEN]

Ahhhh... I should ... I will let you know if I do it and good luck on your marathon! /Ruth

[@olaspanglund3033]

Nice video with a lot of functions but a faster way to solve the 15 min problem is just to subtract one minute before the quotient or int divide. And to be safe wrap in max(0... to avoid negative penalty for early people.

[@CurbalEN]

Thanks for sharing and happy Friday! /Ruth

[@RodWhiteley]

I was thinking the same thing, but thinking of adding 1 second to the start time (or even less) so you have to go that same amount more than 15 minutes so the resultant division "jumps" to the next category. i.e. have the start time 08:00 01 (1 second after 8am)

[@jerrykappa6899]

Hi Ruth, funny functions to use.... Next explore EXCEPT.... it is a cool one and I did not see much examples for it. Enjoy the weekend 😁

[@CurbalEN]

I already covered Except, have you seen it ? m.kzbin.info/www/bejne/in2bYqKmoJpsl6c /Ruth

[@vida1719]

It was fun to watch this in Dax and how some Excel features (I mean converting to true and false) can be applied in Dax.

[@CurbalEN]

Yeah, I was surprised too :) /Ruth

[@denismcsweeney187]

Hi Ruth. Another excellent video. Was wondering if you could also use the expression: Is 15 Min Interval = -INT(MOD([Minutes late, 15) = 0)

[@CurbalEN]

Yes, that is how ExcelIsFun does it in his video :) /Ruth

[@ayobamiologun9184]

Good job Ruth.

[@CurbalEN]

Happy Friday Ayobami :) /Ruth

[@fatjanpaloja9182]

Thumb s up

[@davidcadman3562]

Thanks. Harsh US employer! They should spend some time in Sweden.

[@CurbalEN]

I think that would be illegal here... /Ruth