very well explained, thank you very much for these insights into this function
@luda_c4 ай бұрын
Excellent channel, thank you!
@felipesignorellireis78393 жыл бұрын
Great explanation.
@muskhha2 жыл бұрын
Very handy and useful
@williamarthur48012 жыл бұрын
Good introduction and well explained as ever, here it comes, I would have liked to see the 'long' syntax for the two table filter, as i think that's better when learning how things actually work together. BTW loved the fibonacci sequence.
@user-hz6gw3uk6z5 ай бұрын
thank you.
@jps110862 жыл бұрын
Thanks
@BIGorilla2 жыл бұрын
🔥🙌
@alexrosen87623 жыл бұрын
Great tutorial. Thanks :-)
@BIGorilla3 жыл бұрын
Thank you!
@decentmendreams Жыл бұрын
Thank you so much . When am I going to get a breakthrough on Filters ? I understand everything but can’t write it free flow like you and other pros .In order for me to get to that level I need to understand it as much as I understand 2+2= 4. Otherwise all I do now for complex filter Daxes is copy and paste.
@rogelioluna4220 Жыл бұрын
What do you do if you want to filter 2 color?
@markhenderson3771 Жыл бұрын
How can I use OR with a filter instead of AND?
@shwetajuyal4106 Жыл бұрын
&& for AND and || for OR
@pandianselvaraj92043 жыл бұрын
I need to get max date for each equipment number with condtion If service =x then max date Else '' ' SELECT EQUIPMENT_NBR, MAX(CASE WHEN IN_SERVICE_IND = 'y' then NEXT_INSPECTION_DATE ELSE '2001-01-01 00:00:00' END ) AS maxdate FROM vari.VESSEL_INSPECT_VIEW group by equipment_nbr With above i am getting business logic But when i am try join this table with main table ..i am getting error ..bcz we have duplicate equipment number .. Equipment number with sevice x,y,blank If you have any idea pls help me
@BIGorilla3 жыл бұрын
Hi Pandian. I'm afraid I don't follow the example. Hope you solved it!