Power BI Practice SOLUTION ROUND #1 I RUNNING TOTALS and CUSTOM LABELS in Power BI

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.

--------------------------------
📊 TRAININGS 📊
---------------------------------

---------------------------------
😍 JOIN 😍
----------------------------------

---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------

* 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

[christinelowery]

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 ❤

[NirmalKumar-xwrw]

Perfect video with amazing explanation to the specific point of total. Thanks a lot.

[sandeepreddy]

Thanks Bas for the detailed explanation and love your videos always and looking forward to see many more challenges from you.

[barttitulaerexcelbart]

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?

[wangjessica]

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 ?

[ozGold]

Excellent explanations. Great job!!!!

[CJ-jctn]

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!

[Soulenergy]

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

[abbielmi]

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.

[nikakalichava]

Hey man, not showing off or something but...
5:08 when I used this measure = CALCULATE([No of new releases], it actually calculated running totals... why? Can somebody explain? How it worked for me and did not work in this video? It did not work in the next steps obviously but on this one it did... :?

[ravikanth]

Nice detailed explanation Bas! I love it!

[AbdullohSharipov-cj]

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.

[oricchannel]

Another useful video. Won my like. Looking forward to more videos like this. Thanks for sharing !!!

[brookbracewell]

Really enjoyed this, it helped cement my understanding of a few concepts. A well rout video, and a great beard

[瑞奇-wu]

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?

[dherro]

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] <= MAX(DimDate[Date]) inside the filter function, I would expect the MAX DimDate to equal the very last date for every row/context, which would be in 2020. So the line chart would always be flat hovering around 4000 as the value. But instead, it still returns the max date for that context only, even though it is using the ALL function. Why is that?

Hope this was clear enough.

Thank you!

[officebizsolutions]

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

[kunalgupta]

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

[lydxcarrot]

Quick question: why does the new measure column LastDate shows 1/17 for everything?

[traveldost]

There is already a column date_added, why you have not used that for running total