Probably the best playlist on YT about DAX. I just love the way you teach by building the concept and why we are using the specific formula Thank you so much sir
@@WiseOwlTutorials Just wanted to give you an update. I used your videos for my prep for an interview and I have landed the job :). Thank you again sir!!
Hi Sir, how are you? Sir, for your information "If" statement in VBA is case sensitive. To make it case insensitive, use "Option Compare Text" on the top of the module. I've learnt it from Mr. Excel Forum. Sir, I've a task that I need to do on daily basis. The Task is to compile multiple files in a specific folder through VBA. For your kind information, all Headers are of same spelling as well as in same order. But, the actual problem is, how to pull out or extract only those rows, where Department is either "Sales" or "Marketing" and the Quarter is either "1st Quarter" or "2nd Quarter". Please make a Video on this topic.
Hi Teja, you're very welcome! I don't know why you can't see previous comments but I know that UA-cam automatically deletes comments containing hyperlinks just in case that's the reason.
Hi Andrew, Thanks for great explanation about measures. Further, I'm not able to apply conditional formatting by using Measures. I'm selecting Format By > Field Value Then Measures values not appearing and disabled for selection... Please help
How can I create an average runtime for all films that is NOT affected by ANY filters? You partially do this by using the REMOVEFILTER command but this ONLY applies to Genre's. However, when you use the slicer that slices by certificate, then the average calculated is relevant to that certificate selected. Thats great if you want that, but what if you don't?
Hi! If you check out Part 5.2 in this playlist I think it will help ua-cam.com/play/PLNIs-AWhQzclPj5BGcckuyrOVqRD-7rIX.html&feature=shared Hope it helps!
Hi! You can find a link in the video description which allows you to join the channel. The early access perk is available to members in the Chick tier. I hope that helps!
Probably the best playlist on YT about DAX. I just love the way you teach by building the concept and why we are using the specific formula
Thank you so much sir
Thank you so much for the kind comments and for watching!
@@WiseOwlTutorials Just wanted to give you an update. I used your videos for my prep for an interview and I have landed the job :). Thank you again sir!!
@@parulsharma330 Congratulations! That's great news, good luck in your new role!
Great trick using the REMOVE FILTERS in the calculated measure
Thanks Jonathan!
Excellent Andrew!! , I am learning DAX from Books. But you make everything perfect and simple.
I love You So Much
God Bless
Ahh thank you! I'm happy that the videos are helping you to learn DAX, keep it up!
Awesome Andrew! Thanks for this getting started with measures tutorial. Appreciate all the good tips, tricks and techniques :)) Thumbs up!!
Thanks as always Wayne, glad you enjoyed it!
Merry Christmas to our most Respectable and Priceless Teacher ❤️❤️❤️❤️❤️ 🙏🙏🙏🙏🙏.
And a Merry Christmas to you too Kartick!
Hi Sir, how are you? Sir, for your information "If" statement in VBA is case sensitive. To make it case insensitive, use "Option Compare Text" on the top of the module. I've learnt it from Mr. Excel Forum.
Sir, I've a task that I need to do on daily basis. The Task is to compile multiple files in a specific folder through VBA. For your kind information, all Headers are of same spelling as well as in same order. But, the actual problem is, how to pull out or extract only those rows, where Department is either "Sales" or "Marketing" and the Quarter is either "1st Quarter" or "2nd Quarter". Please make a Video on this topic.
You are AWESOME!!
Thank you Andrew
No, thank you!
Mr. Owl! Thanks very much!
You're very welcome, thanks again for watching!
Thank you very much Andrew!
You're welcome!
Hi Andrew, thank you for the amazing video. I don’t know why I can’t see my earlier comments.
Hi Teja, you're very welcome! I don't know why you can't see previous comments but I know that UA-cam automatically deletes comments containing hyperlinks just in case that's the reason.
Hi Andrew,
Thanks for great explanation about measures. Further, I'm not able to apply conditional formatting by using Measures. I'm selecting Format By > Field Value Then Measures values not appearing and disabled for selection... Please help
Hi Pavan! What type of visual and which property are you trying to apply your conditional formatting to? And what is the code for your measure?
Could it be used ALL Function instead of REMOVEFILTES, you get the same result, by removing all filters from table or table column?
Yes, you could use ALL instead of REMOVEFILTERS. You'll find that there are often multiple ways of achieving the same result in DAX!
How can I create an average runtime for all films that is NOT affected by ANY filters?
You partially do this by using the REMOVEFILTER command but this ONLY applies to Genre's.
However, when you use the slicer that slices by certificate, then the average calculated is relevant to that certificate selected. Thats great if you want that, but what if you don't?
Hi! If you check out Part 5.2 in this playlist I think it will help ua-cam.com/play/PLNIs-AWhQzclPj5BGcckuyrOVqRD-7rIX.html&feature=shared
Hope it helps!
How can I watch other blocked videos on your channel? How much i have to make a donation to have access to these videos? Please inform me in detail
Hi! You can find a link in the video description which allows you to join the channel. The early access perk is available to members in the Chick tier.
I hope that helps!