Power BI Practice SOLUTION ROUND #1 I RUNNING TOTALS and CUSTOM LABELS in Power BI
Vložit
- čas přidán 22. 08. 2020
- 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.io/powerbi-how-to
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatraining.io/pages/powe...
Power BI Essentials datatraining.io/powerbilearni...
Business User Training datatraining.io/powerbi-busin...
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.net/@howtopowerbi
Newsletter datatraining.io/newsletter
---------------------------------
👇 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.epidemicsound.com/referra...
🚀 For growing on CZcams: www.tubebuddy.com/bas
🏄 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
Perfect video with amazing explanation to the specific point of total. Thanks a lot.
Thanks Bas for the detailed explanation and love your videos always and looking forward to see many more challenges from you.
Really enjoyed this, it helped cement my understanding of a few concepts. A well rout video, and a great beard
Nice! Love this format.
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 :)
Nice detailed explanation Bas! I love it!
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 ❤
Excellent explanations. Great job!!!!
Another useful video. Won my like. Looking forward to more videos like this. Thanks for sharing !!!
Great video. Thank you !
Hey man, not showing off or something but...
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!
Great
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.
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?
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 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.
There is already a column date_added ,why you have not used that for running total
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
thank you so much Bas, I'm really learinng a lot about PowerBI thanks to your videos