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

[@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]

same here

[@NirmalKumar-xw2rw]

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

[@HowtoPowerBI]

Glad it was helpful! thx for watching!😃

[@Soulenergy31]

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]

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

[@sandeepreddy7687]

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

[@HowtoPowerBI]

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

[@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 ❤

[@famousjamous2006]

Nice! Love this format.

[@HowtoPowerBI]

More to come!

[@oricchannel2811]

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

[@HowtoPowerBI]

thx so much!

[@CJ-jc8tn]

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]

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

[@Smeetr]

How to get the date dim table

[@Smeetr]

@@HowtoPowerBI How to get the date dim table

[@ravikanth2651]

Nice detailed explanation Bas! I love it!

[@HowtoPowerBI]

thanks! 😃

[@10ozGold]

Excellent explanations. Great job!!!!

[@HowtoPowerBI]

Glad you enjoyed it!

[@wangjessica1275]

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 ?

[@barttitulaerexcelbart9400]

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]

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 [e-mail]

[@brookbracewell]

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

[@瑞奇-w8u]

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?

[@kunalgupta5667]

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

[@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.

[@minhucnguyen5524]

Great video. Thank you !

[@HowtoPowerBI]

thx! Glad you liked it!

[@AbdullohSharipov-c1j]

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]

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

[@traveldost6820]

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

[@Smeetr]

How to get the date dim table

[@lydxcarrot536]

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

[@HowtoPowerBI]

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.

[@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

[@Smeetr]

How to get the dim table

[@abubakrsaadmakyhoun7535]

Great

[@HowtoPowerBI]

Thank you!

[@dherro456]

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]

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]

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