DAX Fridays

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

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

50% 1

In today's video, we are going to go through how to think about Time Intelligence calculations with a specific case: Calculating the number of open orders using DAX.
I read a million years ago a blog post from Gerhard where he explained how to do it and even though we are not going to use the same DAX syntax or functions , we will use his methodology:
blog.gbrueckl....
Here you can download all the pbix files: curbal.com/don...
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
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
☼☼☼☼☼☼☼☼☼☼
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/cou...
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/...
▼▼▼▼▼▼▼▼▼▼
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/pro...
Many thanks in advance!
▲▲▲▲▲▲▲▲▲▲
************
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► goo.gl/bME2sB
#CURBAL #SUBSCRIBE

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

4 окт 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@himanshshakk3083 4 месяца назад

what a clear cut explaination dear thank you

@CurbalEN 4 месяца назад

😃

@mat.frazer 9 месяцев назад

Thank you. As soon as you started with the green dots my headache was listed and there was sense again in this world. Now to continuing watching the video.

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

Wait till you see the purple ones 😂

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

Thank you Ruth! I spent a few hours figuring out the right formula in excel. Then I found this video and this worked perfectly!!! You are awesome!!!

@bettina.e-k 3 года назад

Thank you Ruth, a perfect demonstration of "DAX is all about the filters" 😁 and using Variables for troubleshooting 😊 PLUS really useful technique!!

@annaephgrave1345 Год назад

Thank you so much ... I have been struggling with this for ages, and your explanation has made everything just click into place 🙂

@CurbalEN Год назад

Wonderful!!

@msheaver Год назад

Boom! Mind blown! @5:06, the light bulb went off in my mind, and this is indeed genius!

@CurbalEN Год назад

👏👏👏

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

That’s Great Ruth! Thank you!!! 😊

@sue_bayes 2 года назад

Thank you and makes perfect sense using the Cross Filter

@stuartmccloud307 2 года назад

Great Video, thanks. And I never realised you could zoom the text in the formula bar till now :)

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

I should do it more often ;)

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

Looks so easy when you explain! 😘 Love it!

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

He made it easy for me, I am just passing the knowledge over :)

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

Very helpful! Thank you!

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

Great video, Ruth!

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

Thanks, that blig post helped me tremendously when I got started!!

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

This is fantastic, thank you. I think I understand that the CROSSFILTER is removing the relationship to CALENDAR. If you had multiple relationships from ORDER to CALENDAR you would have to remove those as well or the MONTH field will be bucketing on the UnCROSSFILTERED relationship. Is that right?

@jarnopronk5419 8 месяцев назад

Hi Ruth @curbal, thank you so much for this video. It really helps me with my report. I have one question. I think this measure only looks to the orders that actually have a shipdate. When the orders do not have a shipdate (Orders that are still open) are not in this measure. So when you want to see the open orders of last week, it probably is not as valid as the data of 2020. Can you help me with this?

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

This what I looking for👍

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

Love the video thanks.

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

great video thank you !!!

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

Thank you!

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

Very cool video. 👍 I would only like to ask you to increase the size of visuals, it is hard to see when watching on the phone. Like you did when you were writing a formula, that was easy to see.

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

I try to remember that, but sometimes... will continue trying ;)

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

Thanks for the clear video. Is there a way to show at a point in time only orders that are open for more than x days? I'm trying to make a report that shows in a chart the number of tickets that are open for 30 days or more.

@josefedericopresno6668 2 года назад

Great video and very helpfull. Thanks a lot!

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

Fab to hear!!

@Astronomynatureandmusic 10 месяцев назад

Unfortunately I cannot find correct content for #208 in your download center. It says "Userrelationship with slicers".

@analynoclarit564 Год назад

Thank you for this! Wondering how I can apply this in showing requests or orders than went beyond and within cut off for our management?

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

Ruuuth! Como siempre, muy educativo.

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

Gracias!!

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

Nice, cross filter, first and second item, may switch. Date or order date does not matter

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

Thanks!

@gmartinezm Год назад

Awesome video, what if I want to see in a chart, all the orders Opened (open date) and Closed (closed date) by week, the challenge im facing is that using table calendar with active relationship to active orders, sometimes is not coming back that week with the closed orders (inactive relationship). Not sure why closed orders are not coming back that week. Thoughts?

@yasinsen6301 6 месяцев назад

What about date/time format and categorizing by month? Trying to figure it out for 2 months without any luck.

@bhanuprakash-ql7ut 2 года назад

Hi Curbal can you please expalin bit clearly in relationship model ,what all relationship to be made

@michelleryan8512 2 года назад

This is great! How would I alter this to count distinct? Thank you

@hannafilipowska7962 Год назад

very helpful video, thank you! however I would like to ask - is it possible to use this expression with inactive relationship using "USERELATIONSHIP" function? the following expression I wanted to create doesn't work: CLOSED = var MaxDate=Max('calendar'[Datetime submit]) var MinDate=Min('calendar'[Datetime submit]) return CALCULATE( COUNTROWS( FILTER(events, events[closed_date]=MinDate )) , CROSSFILTER('calendar'[Datetime submit], events[closed_date], None), USERELATIONSHIP('calendar'[Datetime submit],events[closed_date]))

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

Hi Ruth, do you prefer CROSSFILTER instead of ALL function in this case? What is your recommendation?

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

It is more about the model and data when deciding which one to use. Test all the options ( removefilters, all, crossfilter...) and check which one performs better for you.