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

Подписаться 236 тыс.

Просмотров 22 тыс.

50% 1

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 RU-vid: 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

Опубликовано:

1 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 44

@nikakalichava8012 Год назад

Hey man, not showing off or something but... 5:08 when I used this measure = CALCULATE([No of new releases], dimDate[Date]

@MdZeeshan-m9u 7 месяцев назад

same here

@wangjessica1275 2 месяца назад

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 ?

@瑞奇-w8u 7 месяцев назад

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?

@sandeepreddy7687 4 года назад

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

@HowtoPowerBI 4 года назад

appreciate the compliment! definitely more coming :D I hope you like the new challenge

@traveldost6820 4 месяца назад

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

@barttitulaerexcelbart9400 4 года назад

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?

@HowtoPowerBI 4 года назад

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

@CJ-jc8tn 4 года назад

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!

@HowtoPowerBI 4 года назад

thanks for pointing it out. Next video without music track ;)

@Smeetr 2 года назад

How to get the date dim table

@Smeetr 2 года назад

@@HowtoPowerBI How to get the date dim table

@AbdullohSharipov-c1j 5 месяцев назад

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.

@HowtoPowerBI 5 месяцев назад

Got a few videos long and short on setting up a date table step by step… check videos on the channel

@NirmalKumar-xw2rw 3 года назад

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

@HowtoPowerBI 3 года назад

Glad it was helpful! thx for watching!😃

@abbielmi9163 Год назад

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.

@famousjamous2006 4 года назад

Nice! Love this format.

@HowtoPowerBI 4 года назад

More to come!

@kunalgupta5667 2 года назад

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

@officebizsolutions 3 года назад

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

@Smeetr 2 года назад

How to get the dim table

@christinelowery2415 Год назад

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 ❤

@lydxcarrot536 4 года назад

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

@HowtoPowerBI 4 года назад

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.

@oricchannel2811 2 года назад

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

@HowtoPowerBI 2 года назад

thx so much!

@brookbracewell 2 года назад

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

@dherro456 2 года назад

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]

@PeterKontogeorgis 2 года назад

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.

@frezerzelalem4017 Год назад

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).

@瑞奇-w8u 7 месяцев назад

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

@Smeetr 2 года назад

How to get the date dim table

@Soulenergy31 3 года назад

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

@HowtoPowerBI 3 года назад

Thx Saul!!! I am happy to hear you like the format! 😀