[EN] [Power BI Lesson #07] DAX Table Functions: CALCULATETABLE + INTERSECT + EXCEPT + VALUES

[@JDC9076]

I've tried many PBI resources but this is by far the best for me, clearly explained with good examples that you can use in real work scenarios. Thank you Leonardo!

[@hecksongomes462]

O mais legal é entender tudo sem legenda. Aulas de Inglês está valendo a pena kkkk. Obrigado Léo, estava precisando desse exemplo

[@jilalialouane5622]

HBD Leonardo, this is the first time when I write you a message, Thank you very very much for all explications my teacher, you are great, your student Jilali from Morrocco, I hope for you a lot of success and healthy

[@Xperiun_]

Wow! Thanks so much, Jilali! Count on me on your learning journey! I just opened the possibility for you to join my Power BI Complete Course, and we have a special offer until today (Sunday): powerbiexperience.com/en/course/

[@maheshsahu6233]

@@Xperiun_ Whether this course is available in English Language??

[@Xperiun_]

@@maheshsahu6233 here: powerbiexperience.com/en/course

[@kondetinarendra4023]

Many more happy returns of the day Leonardo karpinski, your videos are very impressive and motivational to learn power bi from scratch, You are doing an amazing job....Once again a very happy birthday to you.....................

[@Xperiun_]

Thank you so much, I really appreciate it ;)

[@hit4success]

Happy Birthday Leo. Our PowerBi Hero

[@madurapra]

Wish you a Happy Birthday Leo

[@Xperiun_]

Thanks

[@vipinarora9]

Happy Birthday Sir. God Bless you.

[@Xperiun_]

Thank you so much, I really appreciate it ;)

[@jurgenguns1925]

HBD Leonardo, again good and clear presentation to understand capabilities of DAX functions! Thank you and enjoy the Holidays.

[@Xperiun_]

Thanks, you too!

[@thehungerhunter740]

Happy Birthday Leo. Enjoy your day!!! :-)

[@Xperiun_]

Thank you! 😃

[@saikatchakraborty5536]

Happy Birthday Leo! You are such a wonderful Person... Wishing you Merry Christmas & Happy New Year......!!

[@Xperiun_]

Thank you! You too!

[@theranganath]

Nice video. Explained very detailed. I love it your approach of teaching..

[@Xperiun_]

Great, thank you!!

[@SSM_33]

happy birthday

[@aronmozejko6206]

Greate content. All the best

[@Xperiun_]

Thanks a lot

[@dsapraveen]

Happy Birthday Leo

[@Xperiun_]

Thank you mate

[@gurucool80]

Belated Happy Birthday Leo...!!

[@abdullahhussain3753]

Happy Birthday Leo! have happy and successful life

[@Xperiun_]

Thanks

[@mahabubpeera1000]

#Happy Birthday Sir.. Keep Rocking . Merry Christmas

[@Xperiun_]

Thanks.. Happy new year

[@saifullahkowshir]

Obrigado senhor, continue assim, eu aprendi muito com você,

[@Xperiun_]

Tkz

[@shafeeqniyas5066]

Happy birthday leo🎉🎉

[@Xperiun_]

Thank you so much, I really appreciate it ;)

[@bratiranjan]

Happiest Birthday Leo....hope you had a good one!

[@Xperiun_]

Thank you so much, I really appreciate it ;)

[@pragnyaactivities]

Happy Birthday Leo... Keep rocking

[@Xperiun_]

Thank you so much, I really appreciate it ;)

[@riteshchawla10]

Happy Birthday....and HAPPY HOLIDAYS

[@Xperiun_]

Thank you so much, I really appreciate it. Have a great end of the year

[@luizborda7641]

Happy Birthday! I so glad about yout lessons

[@Xperiun_]

Thank you! 😃

[@ttubaz69]

Happy New Year & Happy Holidays...! Leonardo

[@Xperiun_]

To you and family as well, thank you

[@vishakhakumar3854]

Have a great year ahead!

[@Xperiun_]

To you and family as well, thanks

[@omarlm2220]

man, you are so great and your explanation is clear and easy to understand, but I want to ask a question, the data Analysts salaries are higher than programmers, in your experience?

[@Xperiun_]

Thank you Omar. Yes, data analysts in general have a higher indeed. It depends on many factors, but in my opinion our area is more promising. Have a great 2021.

[@omarlm2220]

@@Xperiun_ thank you, you too, have a great 2021

[@vinodjadhav7334]

Happy Birthday sir.

[@Xperiun_]

Thank you so much, I really appreciate it ;)

[@sailajas2796]

Happy B'day Leo!!

[@Xperiun_]

Thank you so much, I really appreciate it ;)

[@avinashsamrat]

Happy Birthday 🎈🎉🎉

[@Xperiun_]

Thank you so much, I really appreciate it ;)

[@anisshaikh5325]

Happy birthday leo

[@Xperiun_]

Thank you so much, I really appreciate it ;)

[@katakamjosephreddy9848]

Happy Birthday....!!!!!

[@Xperiun_]

Thank you so much, I really appreciate it ;)

[@bimalpbaby676]

Belated HBD man

[@Xperiun_]

Thanks a lot

[@yusufakinrinade5799]

Happy Birthday 🎉

[@rosamaulini177]

Have a great B-Day!

[@Xperiun_]

Thank you so much, I really appreciate it ;)

[@ourlearning157]

Happy Birthday leo...:)

[@Xperiun_]

Thank you so much, I really appreciate it ;)

[@21Ady21]

Happy Birthday!

[@124deepakonline]

Happy Birthday Leo 🥳🥂

[@Xperiun_]

Thank you so much, I really appreciate it ;)

[@sandeepkhawas3367]

Great

[@dharanidhar4875]

happy birthday leo ,can you do small video on multiple country currency conversions to multiple currency like dollar ,pound,euro with monthly ,yearly exchange rates

[@Xperiun_]

Thank you, surely will add a video like this soon

[@ttubaz69]

Happy Birth Day....!

[@Xperiun_]

Thank you so much, I really appreciate it ;)

[@3danim8r1]

Happy Birthday Leo! Great presentation...I have one QUESTION related to that if we want to know the COUNT of customer name who have purchased only Whey protein in 3 CONSECUTIVE MONTHS. How do we calculate that?

[@Xperiun_]

Create three variables, one for each month. Then create a fourth variable with the Intersect between Var1 and Var2. Then another Intersect between Var4 and Var1. Regards

[@voulvarein]

Hello Lenardo Sir, I want this material for practise

[@vmschary]

I've a date slicer with range selection, and I want to set default values to them (default range should Last 12 Months from Current Day's End of Month) and user should have ability to select any date (just not resricting to Last 12 Months) and users don't want to have any additional filters, Is there any possibility, plz help me? Belated wishes Happy bday Leonardo!

[@karthikeyansiva3588]

Happy birthday 🎂 can u please assist where can i get the dataset?

[@Xperiun_]

Thank you, I will not share the dataset for this lesson specifically because it is part of my course, ok? Regards