Thanks for using finance scenarios as an example. We're always dealing with CY, LY, Budget and Forecast and it's often a pain
@HowtoPowerBI
11 ай бұрын
I think a lot of people can relate to that 😅
@TheRealMvV
11 ай бұрын
@@HowtoPowerBIdo you have a video explaining the other calculation items you skipped (YOY, YTD, etc)?
@umityalcin7888
11 ай бұрын
Your expression is very clear and straightforward. First and foremost, I would like to extend my congratulations to you. I have acquired a wealth of valuable information through our interaction
@HowtoPowerBI
11 ай бұрын
that's very niche to hear! thank you 😊
@johnbert9480
11 ай бұрын
I just updated my PowerBI June 2023 version and it is a huge change in my perspective. Thank you so much Bas for putting up videos like this keeping us up to date! 🎉
@HowtoPowerBI
11 ай бұрын
😯 just skipping july, aug, and september!? you dare devil 😉
@redelico1337
11 ай бұрын
I see what you did there
@CinthyaBlois
11 ай бұрын
Calculated groups is amaziiiingggg! Thanks for this video :) I downloaded the material and I tested use a field calculations instead one single measure and it works!!!!! Fantastic!!!!
@500iq6foot8
11 ай бұрын
Thanks for covering this right away. What I really look forward to is seeing the use cases people come up with over the next couple months
@HowtoPowerBI
11 ай бұрын
so many use cases already out there (as everything was already possible before the update)
@paulgallagher2987
11 ай бұрын
Brilliant as always Bas! You've managed to pack so many advanced concepts into half an hour. And explained each perfectly. So useful; thank you.
@HowtoPowerBI
11 ай бұрын
thanks again for watching 😁😊 happy it helped a bit
@pahadianalyst
10 ай бұрын
This is freaking Amazingggggg......Both the Semantic Model and BAS. Infact Bas is more awesome as I would not have understood any of it without this video. Thank you Bas
@TheRealOrangeAde
11 ай бұрын
Thanks Bas, Lots of interesting new elements to work with 🙂
@HowtoPowerBI
11 ай бұрын
You bet! lot of model exploring to do 😉
@RamzyTheDad
11 ай бұрын
Thank you for the quick and informative upload! Cheers!
@HowtoPowerBI
11 ай бұрын
Yea tried to be quick with this update 😅 glad it was helpful!
@matthewshotton86
9 ай бұрын
This is such a game changer for new reports, thanks for all the great content!
@gizemerdemirler7089
11 ай бұрын
you are the absolute best instructor out there!
@Sam-it6nz
2 ай бұрын
Seeking this subject I found this, I hope it can be useful to my project
@AnthonyCua
10 ай бұрын
Thank you so much for going through each and every par of the semantic model. It was so overwhelming at first!
@HowtoPowerBI
10 ай бұрын
glad it was helpful 😊 thx for watching!
@PowerAnalyst
10 ай бұрын
Thank you Bas! your videos are so useful for our learning and development. You deserve to be the Microsoft MVP. If possible share us your learning and success path :)
@arunvignesh1912
11 ай бұрын
Great video , I have been looking into your videos from the beginning and learnt a lot from you ..thank you so much for the great videos .. This is my first comment.. keep up the good work 👏 👏
@HowtoPowerBI
11 ай бұрын
😯🎉 your first comment! .. thanks! 😉 what an honor
@priyaramjee
10 ай бұрын
Fantastic video and super helpful for all the finance scenarios as often we end up zillion measures to cover all this periodic calculations for all the scenarios
@nbandeiras
11 ай бұрын
Thank You so Much Bas. You are the BEST Ever. Your videos are always so helpful. Grateful and Regards from Portugal
@Aquaelus
11 ай бұрын
*our Mentor is back, how wonderful.*
@HowtoPowerBI
11 ай бұрын
😎👊 lovely to b back ;)
@jamesrosicky2912
11 ай бұрын
This is brilliant! Finally I was able to grasp, how to set up an incremental refresh! Thanks a lot!
@HowtoPowerBI
11 ай бұрын
Glad it helped! 😊
@hendrik-stack22
11 ай бұрын
Best comprehensive video on the new features. Thank you very much 😊
@HowtoPowerBI
11 ай бұрын
glad to hear that 😊 thx for watchn
@McKaySavage
11 ай бұрын
Another really great and clear video! Thanks! One issue that came up to me in how you showed calculation groups is that in the matrix, there does not appear to be any header or title that shows the base measure was Actuals vs Forecast. This could lead to problems with end users if someone changes the base measure, forgets to change it back, and the rest of the team goes on making decisions on the report without knowing. Is there some built-in signal on the visual as to the base measure that you didn't show?
@Elektrolite111
11 ай бұрын
Great video. As it’s almost half an hour, it would be really useful if you could split it into chapters so we can skip to the parts of the video we need.
@HowtoPowerBI
11 ай бұрын
thanks, it already has chapters
@Elektrolite111
11 ай бұрын
@@HowtoPowerBI thanks but you can’t see the chapters when you seek through the video in the player
@eligorniak9699
11 ай бұрын
Thanks Bas! You're an amazing Teacher!!! 😃😃
@HowtoPowerBI
11 ай бұрын
thank you so much, that's really nice to hear 😊
@jose6433
11 ай бұрын
Thank you for your videos!! Are amazing!!
@HowtoPowerBI
11 ай бұрын
Thanks for watching them! 😊
@RakeshKumar-r7w5b
8 ай бұрын
H!, Bas I Hope you are good, I Love your Video this the First Time that i have landed on youtube page, Subscribed your in a minute of fraction. You are So Good..... Best Luck.....
@andresmallama2210
11 ай бұрын
Hola cómo estás ? Veo tus videos desde Colombia y me has ayudado mucho en mi proceso, Muchísimas gracias por todos tus videos
@HowtoPowerBI
11 ай бұрын
muchas gracias.M e alegra oír eso.
@businessinsights_AlexRobe
11 ай бұрын
Awesome Video again, Bas - THANKS! @Changing the model to allow Incremental Refresh: when you convert the fact table Date column to datetime: Did you ever come across any issues with the relationship from Date table [Date] to the Datetime-column of the fact table. E.G. filtering, Time intelligence etc. - and if so would you still need an additional date column in the facts table? Thanks again!
@mneama4383
11 ай бұрын
You don’t have any weak content , all is great ❤❤❤❤❤
@HowtoPowerBI
11 ай бұрын
🤗
@wilconagtzaam587
11 ай бұрын
Was waiting for a great video from you, instead of going through the Power BI October 2023 Feature Summary Blogpost! Great job as always, I will share the link with my colleagues.
@HowtoPowerBI
11 ай бұрын
awesome thanks Wilco. and I was waiting for your comment 😉😁
@miguelbenito7992
11 ай бұрын
Row level security!!! Finally. Thanks
@HowtoPowerBI
11 ай бұрын
:p well it was there already, just you can see it now as well in the model explorer
@gilaniseye4267
11 ай бұрын
Thanks Bas for all your hard work! 5:55 Could we apply group calculations for the 2 measures (Rev Actual & Forecast) in the same table/matrix? In your example, you only showed the case for one measure (Rev Actual OR Forecast) Again, thanks a lot for all the brilliant work!
@HowtoPowerBI
11 ай бұрын
Yes you can! 😁 thx for watchn
@megabuilds3007
11 ай бұрын
@@HowtoPowerBI How it can be? Do we need to add measures in calc group? If so we are again creating all the measures right? 🤔
@dutch-man
11 ай бұрын
Try using a Field Parameter 😀
@yulingo5577
9 ай бұрын
Create one column in the table where Actual- forecast and use the column as selected value
@juliestudy1475
10 ай бұрын
That's incredible!!! Thanks for sharing!!
@IM2a1
8 ай бұрын
So many measures I could avoid. Will try in a next model. Thanks!
@jamalelbouatmani3728
11 ай бұрын
Good morning Thank you for your videos are really very interesting, I have a question: to export the Dashboard to Power Point without publishing it on the Power bi service, is there a way to do it Thanks in advance
@HowtoPowerBI
11 ай бұрын
no dont think that is possible
@edwinarchico439
11 ай бұрын
Thank you Bas, loaded with good stuff.
@HowtoPowerBI
11 ай бұрын
thx!!! 😊 .. definitely nice new feature
@DISISNOTFAIR
11 ай бұрын
the problem with calculations groups i faced 2 years ago and i believe its still there is that you cant do conditional formatting as much as you would like. lets say we have calculation group for current period, prior period and % difference. Now highlighting green/red for the % is pretty painful.
@HowtoPowerBI
11 ай бұрын
is possible though
@JohnOttoKnoke
11 ай бұрын
Great video, as always, Baz. Please make a video explaining how to use Power BI (.pbip) save options. Herzliche Grüße aus Guatemala
@HowtoPowerBI
11 ай бұрын
Thanks for the idea! will put it on my list 😁
@sajadahmadi595
11 ай бұрын
just brilliant, Thank you so much Bas
@tomfisher1099
11 ай бұрын
This was your best video yet
@HowtoPowerBI
11 ай бұрын
yey 🎉 :p depends how you measure it though ;)
@ayushsolanki1068
11 ай бұрын
Always Fabulous!!
@HowtoPowerBI
11 ай бұрын
😎👊😊
@frankgovers8420
11 ай бұрын
Bas, kudos. Always impressed by your knowledge.
@samanthapikus3178
11 ай бұрын
Excellent Comprehensive Video!!
@HowtoPowerBI
11 ай бұрын
Glad you enjoyed it! thanks 😎👊
@ОлегПетров-ю4п
11 ай бұрын
Thank you for the video. It was very interesting.
@jorgedelgado4846
8 ай бұрын
Muchas gracias!!! excelente información!!!!
@HowtoPowerBI
8 ай бұрын
Gracias 🙏
@LALA-yg7ny
6 ай бұрын
thanks for sharing, was very helpful. subscribed :)
@felipeemmanuel7328
11 ай бұрын
Excellent video as always master! One question, taking into account the matrix you presented, if you want to present several measures and leave one of them as current and the other measures you present as LY, for example, how can you do this quickly following this logic? I'm from Brazil and my English is still weak, lol. Any questions just ask. Thanks in advance!
@terpstry
11 ай бұрын
Great informative video! Very clear explained.
@minkelcrondon9727
11 ай бұрын
Loved the run through, just updated and was wondering how to tackle the new view
@HowtoPowerBI
11 ай бұрын
happy it helped 😊 have fun exploring
@MinhTamNguyen-jd3uz
10 ай бұрын
Thanks for this tutorial. Very useful! Actually, one of the drawbacks with calculation group in reality is that in the case of using user customization which users are mostly PBI beginners (or even little knowledge), it's very challenging for them to drop & drag the correct wanted measures & understand how it works.
@HowtoPowerBI
10 ай бұрын
in think in most organizations those people would be consuming the reports that are created for them
@murats5863
11 ай бұрын
I appreciate sharing your knowledge with us, thx!
@HowtoPowerBI
11 ай бұрын
thanks for watching 😊
@solangefranco3444
11 ай бұрын
Really good video! Thanks and please continue sharing interest topics like this ☺
@HowtoPowerBI
11 ай бұрын
Sure thing! thanks for watching 😊
@josefedericopresno6668
11 ай бұрын
Great as always, Bas. Thank You so much!
@mahajanbhushan221
11 ай бұрын
Awesome explanation. I always wait for your new videos please keep making such wonderful content :)
@HowtoPowerBI
11 ай бұрын
Thanks a lot 😊 definitely will
@joelvargas8397
10 ай бұрын
I really like how you explain things. Are you able to do some consulting?
@HowtoPowerBI
10 ай бұрын
Let me know your email, we will be in touch
@DarlaW
11 ай бұрын
Love your videos!! I always learn a ton from you!
@sarveshdeshpande1772
11 ай бұрын
Great learning ….. thanks Bas for all your hard work !!!
@HowtoPowerBI
11 ай бұрын
Always welcome
@carstenbuchmann2077
3 ай бұрын
Danke!
@matteotamburri-n1v
11 ай бұрын
this video is fantastic, really useful, thanks!
@HowtoPowerBI
11 ай бұрын
Glad it was helpful! thanks a lot 😊
@marupbi
11 ай бұрын
thanks a lot! great work as always😎
@李泓範
11 ай бұрын
Thanks Bas, as always with awesome content!
@faizaaniba4595
11 ай бұрын
Excellent, Wow 😊 thanks for this video, great content as always !
@HowtoPowerBI
11 ай бұрын
Thanks again for watching 😊!
@Raj-d7d6p
11 ай бұрын
Learnt a lot from your videos. Thanks Bas
@HowtoPowerBI
11 ай бұрын
awesome, glad to hear that 😊
@zelik33
11 ай бұрын
Great video - big thanks !!
@HowtoPowerBI
11 ай бұрын
thank you! 😊
@AngelikaHolzner-k2v
10 ай бұрын
Big question about calculation groups - why can’t I sort the columns in a matrix visual?? This is a show stopper for me…
@papibaquigrafo82
11 ай бұрын
Awesome video!! Thanks for the content!
@HowtoPowerBI
11 ай бұрын
😊😎 thank you
@siddheshamrutkar8684
11 ай бұрын
This video is awesome but by any chance do you have any videos on handing the unbalanced hierarchies..there are many videos but I have one requirement is that I have to show account ids to respect to that account whenever there are any blanks within the levels.
@MrMumumumu
11 ай бұрын
Very useful, thank you so much!
@HowtoPowerBI
11 ай бұрын
Glad to hear that! thx for watching 😊
@blakelane1763
9 ай бұрын
Fantastic! But the portion on PARTITIONS could use a tutorial on it's own.
@timestoryx
11 ай бұрын
Cool 🎉🎉🎉
@HowtoPowerBI
11 ай бұрын
😎👊
@devod4000
11 ай бұрын
This new change is great. Thanks Bas.
@peterhelms-nielsen8838
11 ай бұрын
Hi Bas. At 7:16 you forgot to insert the link to the formatting video - just thought you would like to know ;). Great video as always.
@HowtoPowerBI
11 ай бұрын
aaaah totally forgot! thank you so much for pointing it out
@peterhelms-nielsen8838
11 ай бұрын
@@HowtoPowerBINo problem. Keep up the good work - it is soooo inspiring.
@herambjoshi8546
11 ай бұрын
Thank you Bas for creating such an awesome content for PowerBI. One quick question, would Calculation group work simultaneously for 2 measures or it has to be 1 selected measure at a time?
@HowtoPowerBI
11 ай бұрын
yes it would :)
@dannyyin3273
10 ай бұрын
@@HowtoPowerBI I was hoping to use a Parameter to toggle among several measures, say Rev, Margin, COGS and show only one set of each measure (CY, LY, YoY, YoY%) at a time, but the Values field won't take Parameter. Any thoughts on how to get around that? BTW, brilliant presentation, love it!
@YannickSOUSSOU
11 ай бұрын
Hello Bas. Hope you're good. A part from the content, I like the way you share the screen. What Apps do you use please?
@HowtoPowerBI
11 ай бұрын
thanks a lot :) editing is done in premiere pro, animations in after effect, and audition for the sound
@YannickSOUSSOU
11 ай бұрын
@@HowtoPowerBI Thanks for the reply.
@YannickSOUSSOU
10 ай бұрын
@@HowtoPowerBI please, what do you use to record your screen ?
@RohithN10
11 ай бұрын
Bas, Check out the custom labels in data labels, its not working for many.
@sandeepbarge4699
11 ай бұрын
Hi, thanks for the video. Can you please help me understand, qhen one should use field parameters and when to use calculation groups? Please can u explain the difference in two?
@Victor-eb5vx
11 ай бұрын
Super video as always but I don't understand one thing. After creating a partition in the model and uploading it to the website. We can't download the model again. In that case will only 1 partition always be visible in power bi dashboard?
@karinamatvejeva3164
11 ай бұрын
Thank You 🔥♥️🔥
@FabrizioCiciarelli
5 ай бұрын
Thanks, you are the best!!! A question, why this pbix file does not found on datatraining?
@amankasera4212
11 ай бұрын
Can you show how the "Role" option in "Model" helps to set up dynamic row level security more easily
@HowtoPowerBI
11 ай бұрын
no, still works in the same way
@YuvarajNarayanan
11 ай бұрын
Thanks ! Awesome video
@HowtoPowerBI
11 ай бұрын
😎👊
@Markey0071
11 ай бұрын
MAN you are a Legend 💥💥
@HowtoPowerBI
11 ай бұрын
😎👊 thx for watching!
@luisfernandomacedo1451
11 ай бұрын
Awesome Bass!
@rebekahhenken5805
11 ай бұрын
What if you only want to show a few of the columns in a visual not ALL the Date Calculations in the group?
@raulsanchez3756
11 ай бұрын
Great job Bas!
@HowtoPowerBI
11 ай бұрын
thank you! 😁
@nirmitshah6162
11 ай бұрын
Super helpful.❤
@HowtoPowerBI
11 ай бұрын
👊😎 Glad you think so! thx 😊
@SynonAnon-vi1ql
6 ай бұрын
Hi, a question about security and roles in relation to my org's setup. All our power bi reports are built on top of Azure Data warehouse. And we want to implement RBAC based access to data at warehouse level and authenticated with active directory. In this case, do we have to worry about data access at Power BI level? Thank you!
@iamapatriot
11 ай бұрын
Nice one!
@luigir2459
11 ай бұрын
Thank you for showing this. Quick question. Are you able to condition format a single part of calculated groups?
@HowtoPowerBI
11 ай бұрын
yes you can, there view vids here on youtube and blogs that explain howto
@AnshulMarele-gbaa
Ай бұрын
Hi, I have power query table called "tbl_1". I need to have another table called "tbl_2" sourcing data at "tbl_1" step no. 4. There are other steps also after step#4. I don't want to duplicate table because it was decrease its efficiency. How can it be achieved without duplicating table?
@firetawgc
11 ай бұрын
Amazing!
@HowtoPowerBI
11 ай бұрын
Thank you! Cheers! 👊😎
@nataacevedo57
2 ай бұрын
There is a way to change the language in Date Hierarchy of a graphic?
@ScottValentine
2 ай бұрын
Calculation groups don't seem to exist in the version I'm using. Version: 2.120.963.0 64-bit (August 2023). Not sure if it's to do with using linked data and not imported data, but they aren't there.
@muhammetmuslu4429
11 ай бұрын
Great. Thanks
@HowtoPowerBI
11 ай бұрын
😊
@LashaPower
11 ай бұрын
Can you Show us how to calculate YoY% in to Calculation Items ?
@HowtoPowerBI
11 ай бұрын
you can see the calculation item in the file (see download link in the description)
@ljgaming1589
8 ай бұрын
Is it possible to filter off any measure from the calculation group. For example, there are two measures for total sales and total price. There are three calculation items for current, MTD and YTD. When I put the calculation group item in the report, that will display value from both two measures. But I want to display only total sales under current. Do not need MTD and YTD under current. But need to display total sales and total prices both under MTD and MTD. I will be very appreciated your advice. Thank you in advance
@vishalnasre1251
Ай бұрын
Hey Bas, What could be the reason that we can not download the PBIX files if incremental refresh is set up.
@fedegarcia6526
11 ай бұрын
Bas, the partitions would work if I have one txt per month and I want to refresh it every month and just add the new month without refreshing the other ones?
@chelseazhang0708
5 ай бұрын
Thanks alot, but the powerbi file download page shows error, can you check it
@martinstrnad6860
11 ай бұрын
Hi , at first thanks for nice video. And now I would like to have a question. I have a problem in my report, I took this report from ssrs and remade it for power bi. And problem is this... in ssrs there was sql query behind report and that query took two DATE parameters and then used them in that query... this is the condition in query "Interviews.DateCreated BETWEEN @From AND @To OR Interviews.DateModified BETWEEN @From AND @To" and now in power bi I dont have this condition in my query and I import all the data into that report and then I use filters on that report but problem is that I can use just one date field in my date slicer... so instead of data where interview.DateCread OR interview.DateModified match value from my slicer input I can get data where it matches just one.. for exaplme I can use interviews.DateCreated in my slicer and then I get data based on this filter and thats fine but I also need to check if there is some interview where interviews.DateModified is in range from slicer. How to solve this issue? Thanks Martin
@borisev1097
11 ай бұрын
Impressing as usual! But why is not possible to create perspective in Power BI, just drag n drop the fields into Perspective?
@RichardOliver
11 ай бұрын
I believe it is coming - it just wasn't in this release.
Пікірлер: 217