As I am practising with the data you provide for DAX, I imagine runtime as sales, country as sales representative and genres as products. It feels like a more real life scenario that way :)
If you'd like a sales-based sample dataset you could use Microsoft's Adventureworks database for SQL Server docs.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver16&tabs=ssms Many online tutorials use this database - I just find it really dull 😀
so the Keepfilter imposes a context filtering from within a variable!!? if so, it's a really interesting feature... many filtering tricks can be done using a variable then 🙂
Hi Samir! You can see all of the DAX videos in this playlist th-cam.com/play/PLNIs-AWhQzclPj5BGcckuyrOVqRD-7rIX.html There are 8 more currently available videos after this one and there will be more. I don't have a fixed release date though, sorry!
hello andrew I am working on date table which i was trying to format the month ,but after formating am getting only two month value the other are missing but i have 12 month before formating do u have suggestions on this code date = ADDCOLUMNS(CALENDAR(DATE(2011,12,06),DATE(2014,12,05)) ,"year",YEAR([Date]),"quarter",CONCATENATE("qrt" , QUARTER([Date])),"month",FORMAT(MONTH([Date]),"mmm"),"weekday",WEEKDAY([Date]),"day",FORMAT(DAY([Date]),"dddd"))
GooooOOOOOooOOODDD MOOOOOrrrnniiinng!!! Mr. Wise Owl has open a new video!!!! A great way to start a morning with your tutorials
:D good morning to you too Nika! Happy to hear you're pleased with the video, thanks for watching!
Good to hear from you Andrew.
Hey Teja! Great to see you're still around!
Loving your calm approach to explaining complex concepts in simple terms, with simple clear examples 🙂
Thank you so much, happy to hear that you're enjoying the videos!
Excellent tutorials on wise owl. Always best!!!
Hey Shailesh! Happy to see you!
As I am practising with the data you provide for DAX, I imagine runtime as sales, country as sales representative and genres as products. It feels like a more real life scenario that way :)
If you'd like a sales-based sample dataset you could use Microsoft's Adventureworks database for SQL Server docs.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver16&tabs=ssms
Many online tutorials use this database - I just find it really dull 😀
Thank you very much this video resolves most of my queries with filter context
Happy to hear that, thanks for watching!
Great content 😊
Thanks for the support Matt!
Please keep posting
so the Keepfilter imposes a context filtering from within a variable!!? if so, it's a really interesting feature... many filtering tricks can be done using a variable then 🙂
Indeed, it's useful stuff!
Awesome 👍
Thanks Santosh!
Hi @WiseOwl,
I was truly missing you. Hope you are doing well.
Hey Piotr! Really happy to see you're still here!
when will be the Next video available on DAX area?
Hi Samir! You can see all of the DAX videos in this playlist th-cam.com/play/PLNIs-AWhQzclPj5BGcckuyrOVqRD-7rIX.html
There are 8 more currently available videos after this one and there will be more. I don't have a fixed release date though, sorry!
hello andrew
I am working on date table which i was trying to format the month ,but after formating am getting only two month value the other are missing but i have 12 month before formating do u have suggestions on this code
date = ADDCOLUMNS(CALENDAR(DATE(2011,12,06),DATE(2014,12,05))
,"year",YEAR([Date]),"quarter",CONCATENATE("qrt" , QUARTER([Date])),"month",FORMAT(MONTH([Date]),"mmm"),"weekday",WEEKDAY([Date]),"day",FORMAT(DAY([Date]),"dddd"))
Hi! It looks like you're trying to format the result of the MONTH function. Try this instead:
FORMAT([Date],"mmm")
I hope it helps!
@@WiseOwlTutorials tnx,, andrew it did help