Comparing cumulative metrics for events with different start dates
HTML-код
- Опубликовано: 11 июл 2024
- How to compare time series that occur in different periods by standardizing the timelines to days since a specific event.
Article and download: sql.bi/836030?aff=yt
How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt
The definitive guide to DAX: www.sqlbi.com/books/the-defin... 
Наука
A 17-minute video I'm probably going to spend a few hours rewatching & studying!
That was great! I can see this being useful from a payroll perspective and comparing employees and wages earned over time, and how it varies according to standard hours, overtime etc. Thanks for great ideas and applications 👍🏽
I've just spent 2 weeks doing this same thing for my company. It took a lot of thinking and trial and error. You just showed me how to do the same thing, but better. It gave me a lot of inspiration to improve my report. Thanks!
Bookmarked! This is going to be very useful sooner or later. The smooth and apparently effortless approach proves DAX is strong with Kurt.
I loved the design of the line chart. Also using it as a 1x1 small multiples chart is such a time saver to get the selected value in the title. Great tip!
Brilliant video..will definitely use this
Love your style! Keep em coming
Great job Kurt. Brilliant video looking at some real world problems and developers' struggles. The small multiple trick and addition of selected item as title was a good trick 👍. Thanks.
Great video.
Just one quick suggestion if you can further explain in most important lines what it does WRT to syntax if would be beneficial to viewer ,since most of the viewers are having basic/intermediate level of understanding of the dax and in these examples there are many parts which amalgamate. So viewer might easily lost in the middle.
Another banger from SQLBI and Dax Jesus (Kurt).
Really great information and well presented. I love the content and detailed explanation of how to execute the comparison.
If I had just one suggestion, it would be to add some of that great SQLBI pizzazz. Voice inflection and facial expressions really help to keep the listener engaged for the entirety of the video.
Thanks! And I know, I struggle with that. Working on it 🙂
Just brilliant! Thanx a lot.
Great video, thanks.
Nice - Clear - and a full look at a use case helping to the understanding of why you do X or Y elements
WOW! great video. Loved the tip on using the small multiple visual.
Excellent learning. To rewatch multiple times.
I have been looking for this! thank you!
Really very useful... thanks for sharing!!!
Thanks Kurt, great example ;)
OK, but why is the cacodemon purple?
I solved this same problem for a really important report, I needed to know which of my kids is the better runner, based on their 2k time and their age on the race date. My question is, it was really simple to calculate in Power Query, just needed parameters for their birth dates, so what are the scenarios where this DAX approach would be better?
Hello dear friends, great video as always. I'm having a problem perhaps you can help me. I have a RANKX measure that works perfectly fine except when I apply a filter on the column being ranked.
The measure is like this:
Customer Ranking = RANKX(ALL(Customers[Customer Name]), [Sales Amount], ,DESC, Dense)
It is displayed on a table visual and works well. However, when I apply a slicer filter on Customer Name (the column being ranked) then the rank of that customer increases by 1. So for example if customer James Johnson had a rank of 4 on the table, when I use the slicer to filter James Johnson his rank on the table shows up as 5. This doesn't happen when applying any other filter (e.g. Product Category).
How can I solve this? Customers is a dimension table connecting to the Sales fact table through the column Customer ID.
Thank you very much for the videos as always!
One more strange thing: This doesn't happen when another filter is applied on top of Customer Name. So if I filter for Product Category and then on top of that filter a single Customer Name, the rank is displayed correctly in this case.
It's incredible, but... users only want tables! 😂
Se não aprender com Jesus, ninguém mais poderá ensinar.😂😂