Comparing with previous selected time period in DAX
HTML-код
- Опубликовано: 10 фев 2025
- This video describes how you can create a comparison with the previous time period in a visualization, regardless of whether the time periods are consecutive or not.
Article and download: sql.bi/526183/...
How to learn DAX: www.sqlbi.com/...
The definitive guide to DAX: www.sqlbi.com/...
Every week a learn a new thing from this RUclips channel .Thanks a lot . This really helped me in my ongoing project .Sundays well invested
What a great explanation Mr. Ferrari, thanks for sharing your amazing knowledge with the community...!
After a whole week in finding a solution. your this video makes my work way easy. i was working on price elasticity project. as some products did not sell daily so date gap created problem to use offset to get previous date data to check change in value. I really appreciate.
Alberto I wish you were my professor during studies!!!!! THANK YOU SO MUCH FOR THE WORK YOU ARE DOING!!!
This tutorial is Golden. I have mined and mined for days on end till this Eureka Moment @ SQLBI!
TROP TOP, je cherchais depuis 10 jours et j'allais abandonner. Merci infiniment. J'ai encore appris quelque chose.De plus la traduction ene français me permet de comprendre sans bêtement reproduire MERCI MERCI
Wow this is such a smooth and clean explanation. KeepFilters is a blessing.
Precious! This is exactly what I need. I have a task where Output of one stage this week is an Input for the subsequent stage next week. I already created a column with week number relative to the current week (negative in past, 0 current, positive in future), so I'll just use it for this calculation. Thank you!
Everyday one new thing that makes my learning keep on going, Thanks Alberto
Thanks Alberto !! Everytime you make us learn something new and exciting
This video literally saves me from my job fired, thanks alot
Great Work as always - im very glad you started a youtube Channel. I hope you become the msot popular PowerBi Channel. Nobody else is more than an expert on the topic than you guys. Keep up the good work. It will pay off :)
Amazing! This is a code I was searching for some time. Thank you! I follow you with admiration. Regards.
Genius, I was able to use your code as a base to what I really needed. Thanks for posting!
This is amazing. Thanks for making DAX so enjoyable for us.
Alberto, congratulation, This video is very strong, but you transform in easy.!!
It seems easy when it's explained by you guys! Thanks for sharing!
Alberto, you make DAX sound very simple. In fact, when I get to my keyboard to write the measure, I mostly end up missing some step. Maybe, I need more practice for sure. Cheers!!!
thanks a lot for sharing this. may i know how to compute the growth/variance for this case for selected months too?
Just amasing! THANKS A LOT!!!
Great Video ! Its Really helpful for me and I have one question
That is In second page your slicer is Year Month Name not Year Month Number . I want to know how to do that instead month number we have to put month name in dax ?
Thank you, professor Alberto!
Excellent Video, Thank you Sir.
Thanks Alberto 👍👍👍
It works great on a table, but i have problems when i add the measure as a value in a matrix.
I'm trying to compare the selected week with it's previous week. as selecting week 10, and showing two columns with sales form week 9 and 10
Hey hi in powerbi I want to compare a value for continuous 15 mins if the value is same for 15mins continuously and I need a count 1 for that
This measure doesn’t show in “Total” in the table. Is there a way to have sub/total as well? Many thanks
Thanks for sharing, this is really useful and amazing.
I just have a question, if in my report, i have several slicers. How can i modifiy the mesure? the target is the comparaison calculates with these choices of slicers
Thank you Alberto
Hi
Thank you for the video. I am trying to get a variance for two different time period and the time period is selected basis the end user. Like in the video.
Do advise on the same.
Hi Mr Alberto I can't sort my Year Month in another my table, No YearNumber and YearMonthNumber can help.
sir i have a problem which i wanted to slove that is i wanted to compare between different periods like last 7 days, 14, 30 & Month to date with previous month to date but all these option should be on slicer and the all visuals which resides in the page should reflect the output please suggest me how to do i have tried but i am unable to do it.
This was amazing ! I've used this in my retail 4-5-4 data model but I'm very confused on what I need to change in the previous month formula. When I don't use any filters on my output, it works beautifully! The second I try and filter anything on the visual, it returns in accurate data . I know it has something to do with filter context Inside but I can't understand. Can you or anyone help?
For 4-5-4 look at the formulas here: www.daxpatterns.com/week-related-calculations/
Thanks again for another video. 👍
Thank you for another great video!
Thank you for useful informations.
AMAZING! It helped me a lot!!!
Does it work between years?like dez21 Vs Jan22
Great, as always. Thanks !
Thank You!
in case if there is total we have to show based on selection then?
Very good example 👍
thanks!!!
Very good, i was thinking if we have suppose products or brands in the place of month year ???
Potentially you could use a similar approach - but in which case you compare a product with the previous product? And you don't have the notion of "periods" there.
@@SQLBI thankyou for your response, I got your point, if products are ranked then I can use that rank as a notion for selected previous product.
Very good. Thanks
Do you using a heatmap instead?
Thanks. Sorry for posting the question here. Is it possible to make the names of measures dynamic? If so, can you do a video on it? It would really help in visualising/explaining some reports I have.
No, measure and column names are defined in the model and cannot change. You can dynamically change the title of a visual in a report, though.
@@SQLBI thanks. The thing is that I have several measures in the visual and they all need to change independently of each other.
Ahh amazing plesse bring some real workd scerio problem in DAX...😊
Look at www.daxpatterns.com
This is great. I have a measure that computes the same thing but after creating like 4 different measures to feed the final one...
Now, my question is and I can't figure it out on my own sadly: how to use this measure but to display data for example by Product Category without having to add a date column in the matrix. Even if I keep the date column, as soon as I drill down to Product Category level, the measure shows only blanks.
Any tips here, please?
Try to reproduce the issue using the sample file you can download from the SQLBI website in the related article, and write your question in the comments to the article, it's easier to reply that way.
@@SQLBI will definitely do that, thanks! I have also purchased the Mastering DAX course. Maybe my answer will be there too :)
Muito bom conteudo!!!
Do you have any video explain On-premises data gateway ? instalation and configuration from a SQL Server? tks best regards
We only cover DAX and data modeling - you should look at guyinacube.com/2018/01/10/premises-data-gateway-power-bi-revisited/
Nice
Genius...
Let's say you want to compare 2023 YTD vs 2019 YTD, how would you do that?
made it!!! 1 View - on time :) ... thank you!!