DAX Fridays!

Подписаться 135 тыс.

Просмотров 10 тыс.

50% 1

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

Опубликовано:

17 окт 2019

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 37

@soumikmishra7288 3 года назад

mind says...have a break!! after watching this. But again great video, will start using it. Thanks Ruth :)

@CurbalEN 3 года назад

I know!! I had 2 breaks after making it 😬😬

@ayobamiologun9184 4 года назад

Ruth has succeeded in rolling me up and down everywhere in this lesson... Thank you for showing us these tips.

@CurbalEN 4 года назад

This video was indeed a rollercoaster!! 😂😂😂 /Ruth

@oliveroshea6752 3 года назад

LOL "IGNORE"!! Funny funny funny! Great work Ruth!

@CurbalEN 3 года назад

🤣

@oliveroshea6752 3 года назад

@@CurbalEN An excellent video. I think I will label this one under "entertainment" rather than "DAX that I will use"

@CurbalEN 3 года назад

Makes perfect sense ;)

@davidcadman3562 4 года назад

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.

@CurbalEN 4 года назад

Happy Friday to you too!’ /Ruth

@kennethstephani692 3 года назад

Great video, Ruth!!

@CurbalEN 3 года назад

Thanks!

@jerrykappa6899 4 года назад

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...

@CurbalEN 4 года назад

A multi what??? 😳😳😳 Gooogle!! /Ruth

@jerrykappa6899 4 года назад

@@CurbalEN quick simple explanation www.brightworkresearch.com/inventoryoptimizationmultiechelon/2007/08/multiechelon-definition/

@edududu504 4 года назад

jajajaja muchas gracias por el enorme esfuerzo para explicarnos estas funciones tan... exóticas

@CurbalEN 4 года назад

Verdad? Si son exóticas! 😂😂😂 /Ruth

@jevgenijskaktins1066 4 года назад

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

@CurbalEN 4 года назад

In rare occasions. When I find a good example , I will make a video. /Ruth

@coolblue5929 3 года назад

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.

@RonaldPostelmans Год назад

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?

@Shibz17 3 года назад

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" :(

@prabhuhiremath6902 4 года назад

How to add a slicer filter to output of summarised column? Any help

@marcobaquero6867 4 года назад

Hi Ruth...mmm Im not ready for this stuff yet...Quite difficult for me!...

@CurbalEN 4 года назад

Just remember that it is possible to do, so when you need it, you can comeback here ;) Happy Friday !! /Ruth

@NaraMeerammaTrust 4 года назад

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.

@CurbalEN 4 года назад

I will and happy Friday !! /Ruth

@trulyluscious 4 года назад

Still don't get what is the main purpose of ROLLUP :D

@CurbalEN 4 года назад

I know, as I said in the beginning of the video, you will know when you need it ;) /Ruth

@ikar2k 9 месяцев назад

Enjoy DAX.. if you can 😂

@CurbalEN 9 месяцев назад

😂😂

@coolblue5929 3 года назад

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. 🤦‍♂️

@CurbalEN 3 года назад

It keeps your RAM free for other things ;)