Exploring the SEMANTIC MODEL in Power BI

[@tam260]

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]

I think a lot of people can relate to that 😅

[@TheRealMvV]

@@HowtoPowerBIdo you have a video explaining the other calculation items you skipped (YOY, YTD, etc)?

[@CinthyaBlois]

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!!!!

[@johnbert9480]

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]

😯 just skipping july, aug, and september!? you dare devil 😉

[@redelico1337]

I see what you did there

[@umityalcin7888]

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]

that's very niche to hear! thank you 😊

[@500iq6foot8]

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]

so many use cases already out there (as everything was already possible before the update)

[@paulgallagher2987]

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]

thanks again for watching 😁😊 happy it helped a bit

[@carstenbuchmann2077]

Danke!

[@RamzyTheDad]

Thank you for the quick and informative upload! Cheers!

[@HowtoPowerBI]

Yea tried to be quick with this update 😅 glad it was helpful!

[@gizemerdemirler7089]

you are the absolute best instructor out there!

[@AnthonyCua]

Thank you so much for going through each and every par of the semantic model. It was so overwhelming at first!

[@HowtoPowerBI]

glad it was helpful 😊 thx for watching!

[@peterhelms-nielsen8838]

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]

aaaah totally forgot! thank you so much for pointing it out

[@peterhelms-nielsen8838]

@@HowtoPowerBINo problem. Keep up the good work - it is soooo inspiring.

[@jamesrosicky2912]

This is brilliant! Finally I was able to grasp, how to set up an incremental refresh! Thanks a lot!

[@HowtoPowerBI]

Glad it helped! 😊

[@TheRealOrangeAde]

Thanks Bas, Lots of interesting new elements to work with 🙂

[@HowtoPowerBI]

You bet! lot of model exploring to do 😉

[@arunvignesh1912]

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]

😯🎉 your first comment! .. thanks! 😉 what an honor

[@hendrik-stack22]

Best comprehensive video on the new features. Thank you very much 😊

[@HowtoPowerBI]

glad to hear that 😊 thx for watchn

[@nbandeiras]

Thank You so Much Bas. You are the BEST Ever. Your videos are always so helpful. Grateful and Regards from Portugal

[@gilaniseye4267]

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]

Yes you can! 😁 thx for watchn

[@megabuilds3007]

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

Try using a Field Parameter 😀

[@yulingo5577]

Create one column in the table where Actual- forecast and use the column as selected value

[@pahadianalyst]

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

[@McKaySavage]

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?

[@PowerAnalyst]

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

[@matthewshotton86]

This is such a game changer for new reports, thanks for all the great content!

[@eligorniak9699]

Thanks Bas! You're an amazing Teacher!!! 😃😃

[@HowtoPowerBI]

thank you so much, that's really nice to hear 😊

[@jose6433]

Thank you for your videos!! Are amazing!!

[@HowtoPowerBI]

Thanks for watching them! 😊

[@Sam-it6nz]

Seeking this subject I found this, I hope it can be useful to my project

[@juliestudy1475]

That's incredible!!! Thanks for sharing!!

[@Aquaelus]

*our Mentor is back, how wonderful.*

[@HowtoPowerBI]

😎👊 lovely to b back ;)

[@businessinsights_AlexRobe]

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!

[@DISISNOTFAIR]

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]

is possible though

[@priyaramjee]

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

[@mneama4383]

You don’t have any weak content , all is great ❤❤❤❤❤

[@HowtoPowerBI]

🤗

[@LALA-yg7ny]

thanks for sharing, was very helpful. subscribed :)

[@miguelbenito7992]

Row level security!!! Finally. Thanks

[@HowtoPowerBI]

:p well it was there already, just you can see it now as well in the model explorer

[@wilconagtzaam587]

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]

awesome thanks Wilco. and I was waiting for your comment 😉😁

[@frankgovers8420]

Bas, kudos. Always impressed by your knowledge.

[@murats5863]

I appreciate sharing your knowledge with us, thx!

[@HowtoPowerBI]

thanks for watching 😊

[@edwinarchico439]

Thank you Bas, loaded with good stuff.

[@HowtoPowerBI]

thx!!! 😊 .. definitely nice new feature

[@samanthapikus3178]

Excellent Comprehensive Video!!

[@HowtoPowerBI]

Glad you enjoyed it! thanks 😎👊

[@josefedericopresno6668]

Great as always, Bas. Thank You so much!

[@sajadahmadi595]

just brilliant, Thank you so much Bas

[@andresmallama2210]

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]

muchas gracias.M e alegra oír eso.

[@DarlaW]

Love your videos!! I always learn a ton from you!

[@RakeshKumar-r7w5b]

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

[@Elektrolite111]

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]

thanks, it already has chapters

[@Elektrolite111]

@@HowtoPowerBI thanks but you can’t see the chapters when you seek through the video in the player

[@ОлегПетров-ю4п]

Thank you for the video. It was very interesting.

[@terpstry]

Great informative video! Very clear explained.

[@kiranshenvi2626]

Hi Bas, one query in case if we have 2 existing Semantic models, can we embed in new Sematic model

[@jamalelbouatmani3728]

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]

no dont think that is possible

[@jorgedelgado4846]

Muchas gracias!!! excelente información!!!!

[@HowtoPowerBI]

Gracias 🙏

[@minkelcrondon9727]

Loved the run through, just updated and was wondering how to tackle the new view

[@HowtoPowerBI]

happy it helped 😊 have fun exploring

[@vishalnasre1251]

Hey Bas, What could be the reason that we can not download the PBIX files if incremental refresh is set up.

[@marupbi]

thanks a lot! great work as always😎

[@IM2a1]

So many measures I could avoid. Will try in a next model. Thanks!

[@MrMumumumu]

Very useful, thank you so much!

[@HowtoPowerBI]

Glad to hear that! thx for watching 😊

[@matteotamburri-n1v]

this video is fantastic, really useful, thanks!

[@HowtoPowerBI]

Glad it was helpful! thanks a lot 😊

[@papibaquigrafo82]

Awesome video!! Thanks for the content!

[@HowtoPowerBI]

😊😎 thank you

[@zelik33]

Great video - big thanks !!

[@HowtoPowerBI]

thank you! 😊

[@tomfisher1099]

This was your best video yet

[@HowtoPowerBI]

yey 🎉 :p depends how you measure it though ;)

[@mahajanbhushan221]

Awesome explanation. I always wait for your new videos please keep making such wonderful content :)

[@HowtoPowerBI]

Thanks a lot 😊 definitely will

[@sarveshdeshpande1772]

Great learning ….. thanks Bas for all your hard work !!!

[@HowtoPowerBI]

Always welcome

[@siddheshamrutkar8684]

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.

[@李泓範]

Thanks Bas, as always with awesome content!

[@solangefranco3444]

Really good video! Thanks and please continue sharing interest topics like this ☺

[@HowtoPowerBI]

Sure thing! thanks for watching 😊

[@JohnOttoKnoke]

Great video, as always, Baz. Please make a video explaining how to use Power BI (.pbip) save options. Herzliche Grüße aus Guatemala

[@HowtoPowerBI]

Thanks for the idea! will put it on my list 😁

[@MinhTamNguyen-jd3uz]

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]

in think in most organizations those people would be consuming the reports that are created for them

[@fedegarcia6526]

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?

[@faizaaniba4595]

Excellent, Wow 😊 thanks for this video, great content as always !

[@HowtoPowerBI]

Thanks again for watching 😊!

[@Victor-eb5vx]

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?

[@Odd5Maker]

It is possible to automate the creation of the semantic model each time a create a new workspace?

[@HowtoPowerBI]

what would be the use case for that?

[@Odd5Maker]

@@HowtoPowerBI avoid manual work of repeate same semantic model each time I want to create many workspaces with basically the same semantic model but I want to save time but trying to replicate the semantic model someway

[@Raj-d7d6p]

Learnt a lot from your videos. Thanks Bas

[@HowtoPowerBI]

awesome, glad to hear that 😊

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

[@ljgaming1589]

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

[@ayushsolanki1068]

Always Fabulous!!

[@HowtoPowerBI]

😎👊😊

[@felipeemmanuel7328]

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!

[@luigir2459]

Thank you for showing this. Quick question. Are you able to condition format a single part of calculated groups?

[@HowtoPowerBI]

yes you can, there view vids here on youtube and blogs that explain howto

[@AngelikaHolzner-k2v]

Big question about calculation groups - why can’t I sort the columns in a matrix visual?? This is a show stopper for me…

[@FabrizioCiciarelli]

Thanks, you are the best!!! A question, why this pbix file does not found on datatraining?

[@joel_vargas_css]

I really like how you explain things. Are you able to do some consulting?

[@HowtoPowerBI]

Let me know your email, we will be in touch

[@nataacevedo57]

There is a way to change the language in Date Hierarchy of a graphic?

[@chelseazhang0708]

Thanks alot, but the powerbi file download page shows error, can you check it

[@isframew]

Hey bro!, How are you doing?, Greetings from Chile. I have a question about your Power BI Desktop version.. because I updated it the lastest version (October , 23) from the official page, but it keeps showing the add-visual panel in the right side of the screen, not as yours that it's on the top. Could you help me what version should I download and Install, or what I have to do to get it?. Thanks so much for your time bro, I loyal follower here!

[@SynonAnon-vi1ql]

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!

[@herambjoshi8546]

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]

yes it would :)

[@dannyyin3273]

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

[@vrushalipatil7925]

can we use 2 semantic models in 1 power bi report ?

[@tetyyuliaty3540]

i use power BI semantic from another Visual (2 or 3) and different table, In Power BI desktop can run, but when i publish in power BI service have error, can u help me ?

[@nininya]

Can we use these calc groups in a slicer?

[@HowtoPowerBI]

Yes 🙂

[@amankasera4212]

Can you show how the "Role" option in "Model" helps to set up dynamic row level security more easily

[@HowtoPowerBI]

no, still works in the same way

[@dc-sg8ot]

Does cultures handle date? So we get UK week Monday to Sunday and also not UTC when uploaded to service

[@suzukihonda-l8m]

Is there anyway in power bi import by mean of which I can only update the data which have been changed or inserted in back date.

[@YannickSOUSSOU]

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]

thanks a lot :) editing is done in premiere pro, animations in after effect, and audition for the sound

[@YannickSOUSSOU]

@@HowtoPowerBI Thanks for the reply.

[@YannickSOUSSOU]

@@HowtoPowerBI please, what do you use to record your screen ?

[@SantoshKumar-r2h5m]

Hi, I have a transaction table in power bi,where Two Years Data(Jan-22 to Dec-23),I need cumulative of this amount in matrix with column?(Month-year) with a condition like need cumulative calculation from start of month year and also we have a slicer like Last Year,This Year ,when I select from slicer this year the give last month of previous year values Add with this year values & which month values in (-) they Give Total Cumulative, can you solve this issues, Because it's giving same as we need through Date slicer ,when we use the formula for This year and use in slicer they not give results according to us

[@YuvarajNarayanan]

Thanks ! Awesome video

[@HowtoPowerBI]

😎👊

[@ScottValentine]

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.

[@nirmitshah6162]

Super helpful.❤

[@HowtoPowerBI]

👊😎 Glad you think so! thx 😊

[@timestoryx]

Cool 🎉🎉🎉

[@HowtoPowerBI]

😎👊

[@devod4000]

This new change is great. Thanks Bas.

[@karinamatvejeva3164]

Thank You 🔥♥️🔥

[@sandeepbarge4699]

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?

[@raulsanchez3756]

Great job Bas!

[@HowtoPowerBI]

thank you! 😁

[@Markey0071]

MAN you are a Legend 💥💥

[@HowtoPowerBI]

😎👊 thx for watching!

[@cassimpilodia918]

Hi is calculation groups possible in Power Bi Report Server Version

[@rebekahhenken5805]

What if you only want to show a few of the columns in a visual not ALL the Date Calculations in the group?