DAX Fridays
ฝัง
- เผยแพร่เมื่อ 28 ก.ย. 2024
- 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
Thank you Ruth, a perfect demonstration of "DAX is all about the filters" 😁 and using Variables for troubleshooting 😊 PLUS really useful technique!!
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!!!
Thank you so much ... I have been struggling with this for ages, and your explanation has made everything just click into place 🙂
Wonderful!!
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.
Wait till you see the purple ones 😂
what a clear cut explaination dear thank you
😃
Boom! Mind blown! @5:06, the light bulb went off in my mind, and this is indeed genius!
👏👏👏
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?
Looks so easy when you explain! 😘 Love it!
He made it easy for me, I am just passing the knowledge over :)
That’s Great Ruth! Thank you!!! 😊
Great Video, thanks. And I never realised you could zoom the text in the formula bar till now :)
I should do it more often ;)
Great video, Ruth!
Thanks, that blig post helped me tremendously when I got started!!
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?
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?
What about date/time format and categorizing by month? Trying to figure it out for 2 months without any luck.
Very helpful! Thank you!
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]))
How do i incorporate a distinct count ? Instead of countrows
This what I looking for👍
Hi Curbal can you please expalin bit clearly in relationship model ,what all relationship to be made
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?
Thank you!
great video thank you !!!
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.
I try to remember that, but sometimes... will continue trying ;)
Nice, cross filter, first and second item, may switch. Date or order date does not matter
Thanks!
Great video and very helpfull. Thanks a lot!
Fab to hear!!
Love the idea! What software do you use to record your vids?
Camtasia
I tried it but I see the same number of cases for all months, anyone that had the same issue?
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.
As always 👍
😊
name of the file pls?
Get the file from Gerhard post, he has proper data for you to play with.
Ty so much for the video. I'm waiting for next video to learn how to get the color on the table
Yes, I was thinking to publish it already next week, but I think it will be on 2 weeks instead, but it is coming :)
Unfortunately I cannot find correct content for #208 in your download center. It says "Userrelationship with slicers".
Will this dax work if not all orders have a shipped date?
Love the video thanks.
Thank you and makes perfect sense using the Cross Filter
Working with overlapping time periods is much easier in Excel then in Power BI
This is great! How would I alter this to count distinct? Thank you
Thanks but can't find the PBIX files
The pbix file to get is the one in Gerhard's post :)
Hi Ruth, do you prefer CROSSFILTER instead of ALL function in this case? What is your recommendation?
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.
Ruuuth! Como siempre, muy educativo.
Gracias!!