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

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

How to Power BI

3 года назад

19,819 Просмотров

Ссылки и html тэги не поддерживаются


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

Christine Lowery
Christine Lowery - 17.01.2023 16:28

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 ❤

Ответить
abbi Elmi
abbi Elmi - 03.11.2022 22:32

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.

Ответить
Kunal Gupta
Kunal Gupta - 09.10.2022 18:53

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

Ответить
10ozGold
10ozGold - 13.05.2022 10:24

Excellent explanations. Great job!!!!

Ответить
Brook Bracewell
Brook Bracewell - 16.02.2022 23:21

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

Ответить
Daniel Ong
Daniel Ong - 08.01.2022 17:35

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!

Ответить
Bhai Sahab
Bhai Sahab - 30.11.2021 10:45

How to get the date dim table

Ответить
ORIC Channel
ORIC Channel - 02.11.2021 15:46

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

Ответить
Marco Nardelli
Marco Nardelli - 11.09.2021 12:09

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

Ответить
minh đức nguyễn
minh đức nguyễn - 06.01.2021 13:53

Great video. Thank you !

Ответить
Nirmal Kumar
Nirmal Kumar - 24.11.2020 09:33

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

Ответить
Ravi Kanth
Ravi Kanth - 25.10.2020 08:02

Nice detailed explanation Bas! I love it!

Ответить
lydx carrot
lydx carrot - 05.10.2020 10:04

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

Ответить
C J
C J - 26.08.2020 18:00

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!

Ответить
Bart Titulaer ExcelBart
Bart Titulaer ExcelBart - 24.08.2020 13:13

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?

Ответить
Sandeep Reddy
Sandeep Reddy - 24.08.2020 11:05

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

Ответить
James Duffett
James Duffett - 24.08.2020 01:40

Nice! Love this format.

Ответить
Abubakr Saad Makyhoun
Abubakr Saad Makyhoun - 23.08.2020 23:38

Great

Ответить