DAX Fridays!
ฝัง
- เผยแพร่เมื่อ 17 ต.ค. 2019
- Link to resources mentioned in the video:
Summarize : • DAX Fridays! #14: SUMM...
Addcolumns+summarize : • DAX Fridays! #143: ADD...
Summarize + rollupgroup: • DAX Fridays! #144: ROL...
Summarizecolumns: • DAX Fridays! #145: SUM...
Get Northwind Dataset: • Northwind data source:...
Link to DAX Fridays survey: bit.ly/2MMM4KK
Here you can download all the pbix files: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/contact
▼▼▼▼▼▼▼▼▼▼
If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:
curbal.com/product/sponsor-me
Many thanks in advance!Here you can download all the pbix files: curbal.com/donwload-center
▲▲▲▲▲▲▲▲▲▲
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
************
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► goo.gl/bME2sB
#daxfridays #curbal #SUBSCRIBE
mind says...have a break!! after watching this. But again great video, will start using it. Thanks Ruth :)
I know!! I had 2 breaks after making it 😬😬
Ruth has succeeded in rolling me up and down everywhere in this lesson... Thank you for showing us these tips.
This video was indeed a rollercoaster!!
😂😂😂
/Ruth
LOL "IGNORE"!! Funny funny funny! Great work Ruth!
🤣
@@CurbalEN An excellent video. I think I will label this one under "entertainment" rather than "DAX that I will use"
Makes perfect sense ;)
Thanks. Never in a million years would I have guessed that IGNORE() does that! It's definitely useful though. On the subtotals, I struggle to think of a scenario when I'd want subtotals in a table like that. I'll let you know if it ever springs to mind. Have a great weekend.
Happy Friday to you too!’
/Ruth
Great video, Ruth!!
Thanks!
Awesome video.... I used these functions on multi echelon optimization of stock. That a great way to put together data especially to calculate quickly financial impact exploded by region, category et...
A multi what??? 😳😳😳
Gooogle!!
/Ruth
@@CurbalEN quick simple explanation www.brightworkresearch.com/inventoryoptimizationmultiechelon/2007/08/multiechelon-definition/
Nice video, thanks, only the rollup function i don't understand what it can be used for, the only thing i saw in your video was true or false but no subtotal number. I do like the ignore function explanation. I have noticed that in the data view if you use ignore you indeed see the category with a blank sales, but if i use the same table in the report view it still filters out the blancs. Is there also a possibility by viewing the sales and the blanc values in visualisation view?
jajajaja muchas gracias por el enorme esfuerzo para explicarnos estas funciones tan... exóticas
Verdad? Si son exóticas! 😂😂😂
/Ruth
How to add a slicer filter to output of summarised column?
Any help
It seems interesting as this might be the process going on behind the scenes when you are bringing years, categories, subcategories on the canvas (kind of selecting the right true on subtotals) but apart from DB developers when this might be useful? It's about organizing our data , smth similar to having lots of redundant columns from other tables
In rare occasions. When I find a good example , I will make a video.
/Ruth
On scenario when we need to understand this stuff is when we copy a query from the Performance panel and paste it into DAX Studio.
With my data, I used ignore to identify sales months with blanks, and I fill it with another measure. I got exatly the table that i wanted (year, month, store, products, category and sales), but then, when a try to do a relatioship, between this table and "my stores" or "products", I got the message "a circular Dependency was detected" :(
Hi Ruth...mmm Im not ready for this stuff yet...Quite difficult for me!...
Just remember that it is possible to do, so when you need it, you can comeback here ;)
Happy Friday !!
/Ruth
I don't see much of real time usage of this function . I will post when ever i come across this situation on any of my projects. if any one came across practically, please do let me know. Thanks Ruth for this video.
I will and happy Friday !!
/Ruth
Still don't get what is the main purpose of ROLLUP :D
I know, as I said in the beginning of the video, you will know when you need it ;)
/Ruth
Enjoy DAX.. if you can 😂
😂😂
THANK YOU! THANK YOU! THANK YOU! THANK YOU! Appreciate their effort but, the documentation is gibberish unless you already know how it works, in which case it is crystal clear. 🤦♂️
It keeps your RAM free for other things ;)
This is too much hassle
It certainly is !!
/Ruth