Тёмный

My number 1 trick for TIME INTELLIGENCE | Power BI DAX 

How to Power BI
Подписаться 218 тыс.
Просмотров 51 тыс.
50% 1

In this video I show you how a technique that helps me a lot when I write my time intelligence measures in Power BI. Enjoy the video and subscribe for more videos like this!
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
---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
0:00 Intro
0:30 Make sure you have custom date table
1:06 Show the date filter
3:11 Testing the date filter measure on the functions DATEADD and PARALLELPERIOD
7:15 Calculating a running total using the date filter trick
10:54 End
---------------------------------
😍 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 RU-vid: 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

Наука

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

 

2 июл 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 84   
@arunv1909
@arunv1909 Год назад
out of all the channels this guy always does things something different and surprises , thank you man
@michaeljohnson5371
@michaeljohnson5371 2 года назад
I think it’s TIME everyone used this, I will be. Really enjoying the content and your angle of approach to the regular problems we all encounter. You’ve got my sub, keep it up Bas!
@tariqramadan8755
@tariqramadan8755 2 года назад
What makes your videos different than any Power BI videos is your explanation of your thought process.. It makes a huge difference. Great video as always, New to Power BI but you accelerated my learning ten folds
@HowtoPowerBI
@HowtoPowerBI 2 года назад
Thanks Arnabi, very happy to hear you like this format and way of explanation. more is coming :) stay tuned!
@ChrisSmithFW
@ChrisSmithFW Год назад
Love this. Would be great to see one devoted just to time intelligence. Thanks for this!
@Na-uy4ot
@Na-uy4ot 9 месяцев назад
The date filter trick visualise the period really helped understand this formula. I’ll start doing that every time to double check
@erikdebie7021
@erikdebie7021 2 года назад
Great video! What a great way to visualise the result of your date filter AND now I understand why I need to use the MAX(date) when I am calculating rowcontent before the data of that row. I just discovered this channel, but I will be returning regularly. Goed bezig Bas!!
@HowtoPowerBI
@HowtoPowerBI 2 года назад
dankjewel Erik! happy to hear it helped 😊
@brianligat9493
@brianligat9493 6 месяцев назад
Great tip. I ended up creating pairs of measures - one to show the date ranges, then another to show the real measure (Sales).
@just_pbi
@just_pbi Год назад
Genius way of troubleshooting Time Intelligence issues. Well done and thank you for the share!
@sricharang9537
@sricharang9537 2 года назад
This is a brilliant tip and going to make Time intelligence functions more transparent. Very well presented as well!
@HowtoPowerBI
@HowtoPowerBI 2 года назад
thank you Sricharan! 😀
@overnightgrowth
@overnightgrowth 2 года назад
Very useful tip! I'm always tripping over myself with time intelligence functions.
@catherinegould6662
@catherinegould6662 2 года назад
I am loving your instructions - they are always so relevant to my needs. You seem to come at the real life problems in the most ingenious ways! Keep up the amazing work please! i need it >.
@HowtoPowerBI
@HowtoPowerBI 2 года назад
so nice to hear! 😀 definitely more videos coming 🙂
@lorisean06
@lorisean06 2 года назад
This was an awesome tip. Thank you.
@evedickson2496
@evedickson2496 2 года назад
One of the best channels for Power BI I have seen... thanks for all the videos, super useful 👌
@HowtoPowerBI
@HowtoPowerBI 2 года назад
that's so nice to hear! thank you Eve!!!
@pleblanc1972
@pleblanc1972 2 года назад
I really enjoyed this video. The pace as perfect!!!!
@HowtoPowerBI
@HowtoPowerBI 2 года назад
thanks a lot Patrick! 😀
@Ronnet
@Ronnet Год назад
After watching the Dax for PBI videos from WiseOwl, your videos are a great sequel to it since you assume exactly the basic foundation that WiseOwl provides.
@Pjotterbolte
@Pjotterbolte 2 года назад
Awesome tip! I'm definitely going to use it a lot. Keep up to good work Bas!
@HowtoPowerBI
@HowtoPowerBI 2 года назад
Glad to hear it! Helped me a lot to make those DAX calculations a bit easier 🙂
@dariuszspiewak5624
@dariuszspiewak5624 Год назад
And this is how you can (and actually should) DEBUG your measures. It's a real pity that most people who try their hand at PBI will never know this... Thanks for the demo. More people should watch this.
@sakaix7486
@sakaix7486 2 года назад
This trick is amazing! I will instantly use this. That really helps me, to make sure i show the right data! Thank you!
@HowtoPowerBI
@HowtoPowerBI 2 года назад
happy to hear that, thx for watching!! 😀
@eleftheriosioannidis2144
@eleftheriosioannidis2144 Год назад
Mind blowing and such a time saver when trying to cross check your numbers! Amazing Bas. Echt goed gedaan!
@justmechloe.
@justmechloe. 2 года назад
It will be nice to also graph that time series just to share how the data is visualized. Overall great video; keep it up! I subscribed last week, and you are already one of my top 5 channels.
@sahilsinghal9472
@sahilsinghal9472 9 месяцев назад
Fantastic explanation !
@sebastianxx3687
@sebastianxx3687 2 года назад
From start to finish great explaination. Thanks for sharing.
@HowtoPowerBI
@HowtoPowerBI 2 года назад
thx Sebastian!!! 😀
@ralfhalfar4437
@ralfhalfar4437 2 года назад
Heel goede uitleg. en goede presentatie
@brandonreyes1840
@brandonreyes1840 4 месяца назад
Very good video and very useful. Thank you
@adilumr6359
@adilumr6359 11 месяцев назад
Great video thankyou
@gianpaolo19
@gianpaolo19 2 года назад
Very Very good!!!!! You are really good to explain complicated things! Really enjoy the contents! One of the best channel on Power BI
@HowtoPowerBI
@HowtoPowerBI 2 года назад
Glad to hear you like it! Thanks 🙏:)
@narasimhaprasad847
@narasimhaprasad847 Год назад
Excellent....!!
@anastephania
@anastephania Год назад
Great video! Thank you, I am hoping these tips will work for a custom quarter with a calendar that starts in November. I haven’t tried it yet. 🤞🏽😊
@drac6426
@drac6426 2 года назад
amazing. thx!
@ThepExcel
@ThepExcel 2 года назад
Great tips. Thx!!
@HowtoPowerBI
@HowtoPowerBI 2 года назад
happy you like them, thx for watching!
@Rafian1924
@Rafian1924 2 года назад
Awesome brother
@viniciusfernandes3552
@viniciusfernandes3552 2 года назад
Thanks for sharing bro. Cheers
@HowtoPowerBI
@HowtoPowerBI 2 года назад
Happy you liked it - thx! 😀
@HaiderAli-vt8wn
@HaiderAli-vt8wn Год назад
simply great😀
@HowtoPowerBI
@HowtoPowerBI Год назад
Thx Haider
@cityoflaredoopendatadivisi9197
very useful video. thank you.
@HowtoPowerBI
@HowtoPowerBI Год назад
Glad it was helpful!
@kennethstephani692
@kennethstephani692 2 года назад
Great video!
@HowtoPowerBI
@HowtoPowerBI 2 года назад
Thank you Kenneth! 😀
@thailynguyen
@thailynguyen 2 года назад
Thanks, pls explain why we need the RemoveFilters function in the RT formula?
@ahmadabdelgalil5894
@ahmadabdelgalil5894 9 месяцев назад
Good Work my bro , could u tell me which pro that you use in montage your great videos
@ohboy7857
@ohboy7857 Год назад
this is a great tip ! QQ, how to create a RT if there is no date column, just the Quarter column, with values as 2020Q1, 2020Q2 and so on till 2023Q4
@narendralv6379
@narendralv6379 2 года назад
Thanks! Please avoid background music if possible.
@HowtoPowerBI
@HowtoPowerBI 2 года назад
Thanks for watching and the feedback Narendra! 😀
@datalords
@datalords Год назад
Whenever you need inspiration for your visuals, this is the channel. Subscribe and watch one tutorial a day and in a week/month/year time, thank him for such a quality video.
@tomfyfe6295
@tomfyfe6295 7 месяцев назад
Hi Bas, Loving the videos, haivng just had the issue with running totals, and only just found this one in the list .. :D I have one question, how would you go about re-seting the running total annually, so that you start from 0 each year?
@emmanuelagbo218
@emmanuelagbo218 Год назад
Awesome
@HowtoPowerBI
@HowtoPowerBI Год назад
Thx Emmanuel!
@catherinegould6662
@catherinegould6662 2 года назад
Thanks
@HowtoPowerBI
@HowtoPowerBI 2 года назад
thank a lot Catherine, appreciate your support for the channel!!! 😀
@christofhermdelgado4267
@christofhermdelgado4267 2 года назад
Hey, have you found a way to work with "time/duration" in PBI? Working with hours, minutes and seconds
@auktaviustrojar001
@auktaviustrojar001 2 года назад
Hey there. Thanks for your videos. What about time filters? I would like to know how many calls my call center received between the hours of 9:00 AM and 6:00 PM on in given date period. How can i do that in PowerBI?
@StarfiresDad
@StarfiresDad 2 года назад
@4:39 what did you say??? lol jk Another great video. Keep the awesome work! Clear explanations and an engaging teaching style. 👍👍
@HowtoPowerBI
@HowtoPowerBI 2 года назад
hahaha 😂 guess that my videos get a warning label from now on 😂 .. thx Ty!
@beginho2454
@beginho2454 2 года назад
Nice teacher ;)
@HowtoPowerBI
@HowtoPowerBI 2 года назад
Thank you! 😃
@HulycezCruz
@HulycezCruz Год назад
This is amazing!!! I have a lot of troubles dealing with the difference between each DAX function, it really works for me. Do you have another trick for dealing with ALL, ALLSELECTED, ALLEXCEPT? I get confuse with these measures all the time.
@millar2255
@millar2255 5 месяцев назад
Trying to calculate the 12 month rolling average for a rate (Measure). It doesn't seem to be working and is just returning the same value as the current month's value (not the average of the last 12 months).
@iamfranksthemathsanddatasc2431
How do i deal with dates of form 31st December, 2021 10:16 pm in powerbi. So i am left with date and time recognized by powerbi
@stugryffin3619
@stugryffin3619 Месяц назад
4:39 WHAT DID YOU SAY TO ME BAZ???? 🤣
@TalhaAhmed..
@TalhaAhmed.. 7 месяцев назад
I have been trying this SAMEPERIODLASTYEAR but Matrix visual is not showing any result , it is just showing total at the bottom of the column., that's it. Can you help me please? Plus in some cases it was only showing result in month wise data, not in year wise data
@1973youness
@1973youness Год назад
Hi, it's seems to be a Great Video ... I'm deaf and transcriptions are crucial for me. Unfortunately the transcritption is weird (mix of Vietnamese and Elglish), it's from Vietnamese to translated English (lol ... I've nothing against vietnamese, there are nice people) but here in this context only, the transcription is really bizarre. Please, could set the configuration to auto-transcritpions in order to be more understanble for me ? ... Thanks in advance.
@digitalybonito3237
@digitalybonito3237 9 месяцев назад
I would like to be a English native speaker to be able to say how I really appreciate your videos, I'm learning a lot in the way I Love, with examples. I love my past person who decided to learn English just to be able to follow a English Tutorial without a dictionary on hand. Maybe it sounds crazy, but I love learning with you
@pabeader1941
@pabeader1941 2 года назад
Another let down video. I was really hoping for some Time Intelligence content and all I get is Period Intelligence. Oh well. I'll keep looking.
@HowtoPowerBI
@HowtoPowerBI 2 года назад
ouch 🙁 ... hope you've found what you were looking for
@narasimhaprasad847
@narasimhaprasad847 Год назад
I have made a cash flow report in PBI using the data source from Excel. - The closing balance is arrived from the transactions for the day (i.e balance at the beginning of the day + Receipts for the day - Payments for the day) - The opening balance for the next day shall be the closing balance of the previous day I failed the get the opening balance for the next day from the previous day’s closing balance. given below the sample table May I request you to provide the solution for the above? Particulars 01-Nov-22 02-Nov-22 Opening Balance 50,000.00 21,000.00 Receivables - 8,000.00 Other Receivable - 12,000.00 Total Receipts 50,000.00 41,000.00 Payments 24,000.00 1,000.00 Other Payments 5,000.00 800.00 Total Payments 29,000.00 1,800.00 Closing Balance 21,000.00 39,200.00
@rajeshkumarneelam380
@rajeshkumarneelam380 2 года назад
Thanks
@rajeshkumarneelam380
@rajeshkumarneelam380 2 года назад
Ur videos are awesome 🙌🙌🙌
@HowtoPowerBI
@HowtoPowerBI 2 года назад
Thank you so much Rajeshkumar for your kinds words and support! :)
@paulgallagher2987
@paulgallagher2987 2 года назад
Thanks
@paulgallagher2987
@paulgallagher2987 2 года назад
Your videos are helping me so much. I'm so grateful. Have a beer on me Bas. :)
@HowtoPowerBI
@HowtoPowerBI 2 года назад
thank you so much Paul - that's a big beer!!! 😃🍻 cheers!
Далее
Penalty: Portugal - Slovenia
02:03
Просмотров 1,3 млн
3 Power BI Visuals You Haven't Seen Before!
17:19
Просмотров 26 тыс.
Optimizing time intelligence in DirectQuery
18:09
Просмотров 5 тыс.
DATE TABLE for Power BI using Power Query
21:26
Просмотров 130 тыс.
Развод с OZON - ноутбук за 2875₽
17:48