Power BI Practice SOLUTION ROUND #1 I RUNNING TOTALS and CUSTOM LABELS in Power BI
HTML-код
- Опубликовано: 17 окт 2024
- In this first Power BI Practice Round we explore a dataset on netflix movies and series. Use DAX to calculate the running totals and try to add a custom label to the last data point of a line chart. Share the solution with us and the community to get feedback.
Requirements:
Key visual:
Create a measure that returns the running total number of releases (cumulative sum).
Visualise it on a line chart - put Year and Month on the axis.
Add a label for the last data point only that shows the total number of releases.
Explore the data set - Some topics to get you started:
How is Netflix changing its focus between movies and series.
What are the key categories.
What content is available in different countries.
Download file here datatraining.i...
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatrainin...
Power BI Essentials datatraining.i...
Business User Training datatraining.i...
For Custom Trainings and Consulting email directly support@datatraining.io
---------------------------------
😍 JOIN 😍
----------------------------------
Join bit.ly/4b453bi
Subscribe bit.ly/31MnQGO
Insta / howtopowerbi
LinkedIn / basdohmen
TikTok / how.to.power.bi
X / howtopowerbi
fb / howtopowerbi
Threads www.threads.ne...
Newsletter datatraining.i...
---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear amzn.to/47F21Yc
📚 Power BI books MUST READ! amzn.to/3tUfFcj
💡 General books I recommend amzn.to/48YNo33
🎶 Music for my videos www.epidemicso...
🚀 For growing on RUclips: www.tubebuddy....
🏄 Stuff I use daily amzn.to/3HqfMQ2
Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!
Thanks for being a part of this channel and all your support! 💪 🙏
#HowToPowerBI #PowerBI #DataTraining
#powerbidesktop #powerbitraining #powerbideveloper #DAX
Hi. Thank you for the video? What is the difference between all and remove filter? Why can't we use remove filter instead for the first challenge ?
Hey man, not showing off or something but...
5:08 when I used this measure = CALCULATE([No of new releases], dimDate[Date]
same here
Thanks Bas for the detailed explanation and love your videos always and looking forward to see many more challenges from you.
appreciate the compliment! definitely more coming :D I hope you like the new challenge
Perfect video with amazing explanation to the specific point of total. Thanks a lot.
Glad it was helpful! thx for watching!😃
Excellent explained Bas! Also very good that you first make "mistakes" and try to explain them, then this is what happens in practice. In one of your previous videos you showed quick measures. I tried the running total there but without succes. Maybe you can explain why the quick measure of running total did not work?
thanks Bart :D ! I just gave it a try and it worked for me. Could you send me the file then I'll have a look bas.dohmen@datatraining.io
I would love to see how to do do 12 week rolling total per category. Your videos are my favorite. I love how you explain it ❤
Well defined and explained video. I have question about formating the visual. When i go over the axis of the visual and i try to select the concatenate option(on/off) nothing happen . The chart 's axis still the same . Any idea?. Much appreciated. I really likes your videos. Excellent teacher.
Nice! Love this format.
More to come!
Excellent video and well explained format. If I could make one minor suggestion, it would be to turn off the background music as I find it distracting while trying to learn your tutorials. Keep up the great content!
thanks for pointing it out. Next video without music track ;)
How to get the date dim table
@@HowtoPowerBI How to get the date dim table
Another useful video. Won my like. Looking forward to more videos like this. Thanks for sharing !!!
thx so much!
Awesome tricks!!!! thanks for sharing, I love the format of your videos where you show your screen and yourself, it feels like an actual face to face class :)
5:43 running total
Thx Saul!!! I am happy to hear you like the format! 😀
Excellent explanations. Great job!!!!
Glad you enjoyed it!
Nice detailed explanation Bas! I love it!
thanks! 😃
thanks for the video, one thing that i find would be plus for me is that you would also show us how you created that dimdate table. I am writing all the codes, i understand the logic but could not do that part properly. Because i am a new user of power bi.
Got a few videos long and short on setting up a date table step by step… check videos on the channel
Really enjoyed this, it helped cement my understanding of a few concepts. A well rout video, and a great beard
thank you so much Bas, I'm really learinng a lot about PowerBI thanks to your videos
one question: I copied your dimDate table and the first definition of running total measure but when I added ALL to dimTable in the FILTER clause, nothing happens, meaning my measure keeps displaying the measure in the year-quarter context
any idea? :-)
marco
How to get the dim table
Hi Bas, great video and series. Love the format.
Quick (or not so quick) question:
Why does the ALL() function here remove the lower limit filter context, but keep the MAX filter context?
For example, when you use dimDate[Date]
Hey Daniel, when you refer to a value with an aggregate (in this case max date) it always refers to the current filter context only. The non aggregated attribute is the one coming from the ALL(Date) context.
What I understood is that applying the ALL() removes every filter coming from in/outside. Its result is kept in the DateLast variable by computing the max date removing every filter. It just see the MAX date of the entire date column which return the last date in 2020 Q1. But the DateMax variable calculates the max date within the current filter context (every row on the table) which return the last date for every quarter. The two results come to equal only at the last date of the data set (last date of 2020 Q1).
not sure if the problem you met solved, i met the same problem, MAX dim date didn't catch the latest date in the fact report but use the date in dimDate table, don't know how to fix it
when i copyed the same DAX to my report, Max(dimdate) didn't reflect the max date when have the value in the fact report but reflect the max date in dimDate table which is the end of the year, and the result become 999, how to fix it?
Quick question: why does the new measure column LastDate shows 1/17 for everything?
The measure LastDate returns the most recent date in the data set. The ALL function is wrapped around the column dimDate[Date] and removes any filter on dimDate[Date]. So this function overwrites the filter context from the table visual with respect to dimDate[Date] and therefore it returns 1/17 for everything.
I have a doubt, I don't understand why the second measure no of new release rt 2 doesn't need all function, isn't the measure is same as measure 1
Great video. Thank you !
thx! Glad you liked it!
There is already a column date_added ,why you have not used that for running total
How to get the date dim table
Great
Thank you!