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.
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?
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.
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?
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?
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]))
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.
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.
![F.HERO Ft. JSPKK x ลำไย ไหทองคำ x M-PEE - ไม่สนิทบิดหมด (Thai Riders Anthem) [Official MV]](http://i.ytimg.com/vi/kPJZ0UihBfk/mqdefault.jpg)
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. 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 😂
Thank you Ruth, a perfect demonstration of "DAX is all about the filters" 😁 and using Variables for troubleshooting 😊 PLUS really useful technique!!
Thank you so much ... I have been struggling with this for ages, and your explanation has made everything just click into place 🙂
Wonderful!!
Boom! Mind blown! @5:06, the light bulb went off in my mind, and this is indeed genius!
👏👏👏
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?
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?
what a clear cut explaination dear thank you
😃
Thank you and makes perfect sense using the Cross Filter
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.
That’s Great Ruth! Thank you!!! 😊
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?
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?
Great Video, thanks. And I never realised you could zoom the text in the formula bar till now :)
I should do it more often ;)
Looks so easy when you explain! 😘 Love it!
He made it easy for me, I am just passing the knowledge over :)
Great video, Ruth!
Thanks, that blig post helped me tremendously when I got started!!
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]))
This is great! How would I alter this to count distinct? Thank you
What about date/time format and categorizing by month? Trying to figure it out for 2 months without any luck.
Unfortunately I cannot find correct content for #208 in your download center. It says "Userrelationship with slicers".
Hi Curbal can you please expalin bit clearly in relationship model ,what all relationship to be made
Very helpful! Thank you!
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.
Will this dax work if not all orders have a shipped date?
Love the video thanks.
This what I looking for👍
great video thank you !!!
Love the idea! What software do you use to record your vids?
Camtasia
How do i incorporate a distinct count ? Instead of countrows
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 ;)
Thank you!
Working with overlapping time periods is much easier in Excel then in Power BI
Great video and very helpfull. Thanks a lot!
Fab to hear!!
Nice, cross filter, first and second item, may switch. Date or order date does not matter
Thanks!
Thanks but can't find the PBIX files
The pbix file to get is the one in Gerhard's post :)
Ruuuth! Como siempre, muy educativo.
Gracias!!
I tried it but I see the same number of cases for all months, anyone that had the same issue?
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 :)