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?
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.
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?
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.
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.
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?
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 Ruth, a perfect demonstration of "DAX is all about the filters" 😁 and using Variables for troubleshooting 😊 PLUS really useful technique!!
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 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!
👏👏👏
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?
what a clear cut explaination dear thank you
😃
Thank you and makes perfect sense using the Cross Filter
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?
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.
Looks so easy when you explain! 😘 Love it!
He made it easy for me, I am just passing the knowledge over :)
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?
Unfortunately I cannot find correct content for #208 in your download center. It says "Userrelationship with slicers".
That’s Great Ruth! 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]))
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.
Great video, Ruth!
Thanks, that blig post helped me tremendously when I got started!!
Great Video, thanks. And I never realised you could zoom the text in the formula bar till now :)
I should do it more often ;)
What about date/time format and categorizing by month? Trying to figure it out for 2 months without any luck.
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 ;)
Very helpful! Thank you!
This is great! How would I alter this to count distinct? Thank you
Will this dax work if not all orders have a shipped date?
Love the idea! What software do you use to record your vids?
Camtasia
Hi Curbal can you please expalin bit clearly in relationship model ,what all relationship to be made
Love the video thanks.
This what I looking for👍
great video thank you !!!
Thank you!
Ruuuth! Como siempre, muy educativo.
Gracias!!
How do i incorporate a distinct count ? Instead of countrows
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 :)
Working with overlapping time periods is much easier in Excel then in Power BI
As always 👍
😊
I tried it but I see the same number of cases for all months, anyone that had the same issue?
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 :)