Thanks Imran, that's very nice of you to say. I'll be dropping my next video this week (I hope) - How to create Power BI reports, Faster. I'm going to showcase one way that, with enough preparation, you can "make a report" in 5 minutes . I hope you'll find it of the same quality as this one :)
I gained a lot of knowledge watching this video. Easy to understand, very well explained and engaging at the same time. Thanks for helping us be better PBI users.
Just watched your video. The part about using Tabular Editor to quickly create all the common measures I need, using a script, is going to save me so much time on projects. Excellent, easy to follow video with clear examples; just what I needed :) Looking forward to checking out your other videos. Thanks
Only with creating the basics measures one can save a lot of time. The script in Tabular editor is easy enough to even make a bit more complicated measures that you may need in a report. Really great. Thanks!!!!!
I’m at my learning stage. I spend a good amount of time doing research. This video is the best I have ever come across. It explanatory nature, the knowledge and the positive energy from the video creator is out of this universe. You are the best of all. Thanks 🙏🏽
Awesome video!! Will definitely try Bravo for the time intelligence functions. Asides saving time, it will also serve as a great way to learn the formulas of different time intelligence functions. Good thing Power BI doesn't store measures in memory so no issues in having lots of measures, even though I might not use all in a report at the same time.
Thank you for this video! I have been attracted by the 1000+ in the title. 10 attribute columns && 10 measures && 10 time-intelligent calculated group with using field parameters, I can definitely create 1000 measures. (this is a fun fact not a real fact)
@@PowerBIPark I would love to see something like this covered, data -purchase details items from vendors for more years (value entries Nav), total paid per line, etc. >> ABC analysis over a timeline to get insight in the percentage we paid more per year per vendor, I would like to benchmark that with avg industry metrics and to get an index we can use for the sales prices for those particular items. Anyway, you can explain very good and I wish you many subscribers
Great video. I would love to see some advanced modelling techniques as I think we do not have great videos regarding advanced modelling techiques like many to many, SCD, handling hierarchies etc.
Nice video man! It definitely shows the potential of Power BI add-ins. I have only used the native environment to create my code. I'm wondering if I am holding myself back by doing that.
I wouldn't say external tools are required for powerbi development, but they really do help. There's some things you can't do without tabular editor, like creating calculation groups of Object-level security - I highly recommend just trying a few things out :)
Hey, so the download links are in the description. They should connect automatically to your powerbi, under the extension tab in your ribbon. Hope this helps! 😊
This has blow my mind. Thank you so much!!! i have done the general sum script which adds up columns but is there a script that gives you sales filtered through a column without creating a measure for each one manually. currently i will have to create loads of measures for 100+ catergorys but hopefully there is a way i can type something like the below into this editor and it will do it all for me? CALCULATE( SUM('Sales Reports'[Nett]), 'Sales Reports'[Analysis Description] = "catergory 1") If not, no worries. Thanks for the video and for showing me this Bravo software. It is crazy how much time all those auto measures have saved me!!
Hey I really hope this video has helped in some way - so the way I would do that is to create a list in excel with all the categories, then make a formula to generate the script. I've made like 700+ measures in one go this way once. For sure what you need to do is just type out the advanced script into excel, and just modify it so that the formula changes based on a specific column, and put the category in that column. I hope that's enough instruction to help 😁
Thank You. Your way ow the reaching is clear and simple for beginners. I am wondering if You have course on some education platforms like Udemy. If so, please let me know.
Thanks for the video. Can you comment on the impact on the datamodel runtime performance (if any) caused by having 1000+ measures even if they not all referenced in the app...
Hi David, so if measures are not called in the application, then there should be 0 effect on performance - it just lives as metadata. That being said, it's still terrible practice - I mention in the video this is just a showcase. There is another external tool called the measure killer - which can be used to remove measures that are not referenced, and could be used to great effect here. I hope this helps :)
Great video. I would request yo u to please make video on showing how to use shape map with geojason file. you can use the geojason of indian states( india), cause it is really frustrating to see that why powerbi don't read geojason file as they promise.
This is amazing but i had a problem with the Bravo in Time Intelligence tab date table and financial tables are not appearing any particular reason for that?
@@PowerBIPark yes for confirmation I use a different dataset and then tried with bravo and it actually worked but showing the same results for all the time intelligence functions. I didn't exactly know what is the reason behind this
Hey thanks for the question you can either Google vertipaq analyzer download or select the link in my description. It's an excel addin, so it means you need to use the specific excel file from the link. Hope it helps!
is there a way I can create this but by only having one value of columns and create those measures based on the rows as we do using the calculate function?
I know what you mean, technically you could use excel to generate code for doing this. I don't think tabular editor can generate code in this way, but I've used rows in excel and generating the scripts line by line before - it totally works and I've changed 1000+ measures this way by simply using excel formulas and substituting cells into the formula text Does that help? :)
Technically there's a couple of ways, such as using notable, code interpreter, or even google sheets. I don't have a video on this yet, but I will consider making one soon
Hi Deepak, the dataset used is the sample data that is in every power bi desktop. If you follow the same steps in the video, you should be able to generate the same data yourself. Hope it helps!
This is not the best way to do this, sorry. You would be better off using calculation groups - one calc group for each aggregation type (avg, max, min,etc...), and another calc group for Time Intelligence (MTD, QTD, YTD, PY, etc..). The way you're doing it makes for a horrendous data model. Calculation groups are much cleaner and keep the model trim. It is all done in the software you are using as well, Tabular Editor. Anyone who reads this, I would highly recommend you research calculation groups instead of doing it this way.
Hi Kass, thanks for the comment, I do say the same thing explicitly in the video 😅😅 I'm working on a video about calculation groups, maybe that will be more what you'd like to see 👍
Hi Power Bi Park, thanks for the video: showcase on what external tools can do for beginners. @kaas, thanks for your observations too, kindly link up with park to start a joint series!
What an impressive start to your PoeerBI youtube series! Amazing, thank you for sharing! Looking forward to more of your content!
Thanks Imran, that's very nice of you to say. I'll be dropping my next video this week (I hope) - How to create Power BI reports, Faster. I'm going to showcase one way that, with enough preparation, you can "make a report" in 5 minutes . I hope you'll find it of the same quality as this one :)
I gained a lot of knowledge watching this video. Easy to understand, very well explained and engaging at the same time. Thanks for helping us be better PBI users.
Thanks for the feedback Carlos, I'm glad this was useful to you!
Impressed... Subscribed... and hit the bell Icon for all notification... Wonderful bro... keep growing...
this is the best thing I ever seen so far on youtube today...
Just watched your video. The part about using Tabular Editor to quickly create all the common measures I need, using a script, is going to save me so much time on projects. Excellent, easy to follow video with clear examples; just what I needed :) Looking forward to checking out your other videos. Thanks
Im really glad that you found this useful 😁 thanks for the feedback!
Only with creating the basics measures one can save a lot of time.
The script in Tabular editor is easy enough to even make a bit more complicated measures that you may need in a report.
Really great. Thanks!!!!!
I’m at my learning stage. I spend a good amount of time doing research. This video is the best I have ever come across. It explanatory nature, the knowledge and the positive energy from the video creator is out of this universe. You are the best of all. Thanks 🙏🏽
Glad it was helpful!
Great video with simple steps. Looking forward to seeing more videos using external tools.
Thanks David!
Nothing short of excellent. So so useful, great presentation. THANKS SO MUCH!
Thanks for the feedback Erica, I hope this is useful to you! :)
Whoa!
Awesome video!! Will definitely try Bravo for the time intelligence functions. Asides saving time, it will also serve as a great way to learn the formulas of different time intelligence functions. Good thing Power BI doesn't store measures in memory so no issues in having lots of measures, even though I might not use all in a report at the same time.
Thanks for the feedback John!
Awsome, I didn't know for Bravo that can be used for external tools. Thanks for sharing with us 😊
This is just an amazing video and also really great explanation. I am a new Fan 👌
Thanks man, I've been putting off uploading new content for a bit but comments like yours really motivate me to get back in ☺
Thank you for this video! I have been attracted by the 1000+ in the title.
10 attribute columns && 10 measures && 10 time-intelligent calculated group with using field parameters, I can definitely create 1000 measures. (this is a fun fact not a real fact)
It's not business useful directly, but still hopefully something that can be valuable for you in the future :)
Very informative video. Can't wait to try out these tips! Thanks a lot.
Great video and nice to know about Bravo, Dax Studio, and Tabular
Thanks Ronald! I hope you try some of these out yourself if you haven't already :)
Great stuff about powerbi.... looking forward for more such interesting stuff 👍 😀
Thanks Diwakar, I hope that my content becomes something that gives you value in your own projects :)
Started with a bang... Good one bro...
Thanks man, next one will hopefully wow you just as much
Great video to showcase what you can do with these tools. Thank you ! keep up the good work. Now subscribed 😊
Awesome, thank you!
I appreciate you saving me a ton of time with this
Awesome!! Can't wait for next videos
Thanks Martin! :)
Great video , it opens a new way for thinking , really good job👌
Thanks Mohamed, I hope you get to use bravo as well 👍
Very cool video. You have talent for teaching. I would love to know more about more external tools. I didnt even know this feature on PBI.
Good, keep on the good work, looking forward to next vid
Thanks Erik! Any topics that you'd particularly like to see?
@@PowerBIPark I would love to see something like this covered,
data -purchase details items from vendors for more years (value entries Nav), total paid per line, etc. >>
ABC analysis over a timeline to get insight in the percentage we paid more per year per vendor, I would like to benchmark that with avg industry metrics and to get an index we can use for the sales prices for those particular items.
Anyway, you can explain very good and I wish you many subscribers
You just got a new subscriber. Excellent work!
Thanks, I appreciate it 😁
This is great content. Looking forward to more of your videos
Thanks for the feedback. More to come!
Great content! Subscribed
crystal clear explanation, thanks a lot
What an interesting, well put together video. I learned a lot! Thanks!
Glad to hear it!
Amazing! Thanks a lot! Great start 👏👏👏
Thanks Francisco!
Great Job Injun
Great video. I would love to see some advanced modelling techniques as I think we do not have great videos regarding advanced modelling techiques like many to many, SCD, handling hierarchies etc.
Hey I'll definitely have this in mind, thanks for the suggestion.
This was amazing - thank you
Fantastic! Thank you!
A video on calculation groups would be great
I promise you'll see that in my 3rd video :)
Wonderful video, welldone
Nice video man! It definitely shows the potential of Power BI add-ins. I have only used the native environment to create my code. I'm wondering if I am holding myself back by doing that.
I wouldn't say external tools are required for powerbi development, but they really do help. There's some things you can't do without tabular editor, like creating calculation groups of Object-level security - I highly recommend just trying a few things out :)
Awesome stuff. Thank you!
Thanks for the feedback Kaden!
Very useful its alot time saver👍
This is Brilliant
Very nice video. Love it. Can the external tools perform “weighted average” ?
Thanks :) so not 100% sure what you mean, if there is a column and a weight% to be applied, I think you could create a measure for that
Great nicely explained cam i use in real scenario
Fantastic job, thanks for sharing
Thanks for watching!
Cool video. I haven't been able to install Bravo yet because I'm not an admin, but I may ask for IT to install it now...
They just updated it to v0.9.6, and just for the date table creation alone I'd say it's worth it. Hope you get to use it!
That's cool ... I like the Bravo 👍👍
Thanks Sarvesh! I like it too :)
U should cover that type of dax in power bi which mostly use in sql during practical work
Awesome.....how to download tabular editor and bravo connect with power bi? ..can you please explain.?
Hey, so the download links are in the description. They should connect automatically to your powerbi, under the extension tab in your ribbon. Hope this helps! 😊
@@PowerBIPark thank you so much..
This has blow my mind. Thank you so much!!!
i have done the general sum script which adds up columns but is there a script that gives you sales filtered through a column without creating a measure for each one manually.
currently i will have to create loads of measures for 100+ catergorys but hopefully there is a way i can type something like the below into this editor and it will do it all for me?
CALCULATE(
SUM('Sales Reports'[Nett]),
'Sales Reports'[Analysis Description] = "catergory 1")
If not, no worries.
Thanks for the video and for showing me this Bravo software. It is crazy how much time all those auto measures have saved me!!
Hey I really hope this video has helped in some way - so the way I would do that is to create a list in excel with all the categories, then make a formula to generate the script. I've made like 700+ measures in one go this way once.
For sure what you need to do is just type out the advanced script into excel, and just modify it so that the formula changes based on a specific column, and put the category in that column. I hope that's enough instruction to help 😁
Brilliant!
Awesome video !
Thanks Ahmed!
Thank You. Your way ow the reaching is clear and simple for beginners. I am wondering if You have course on some education platforms like Udemy. If so, please let me know.
Thanks, perhaps in the future I will make something like this :) I honestly just started making videos 1 month ago, so I'm not there yet.
Thanks for the video. Can you comment on the impact on the datamodel runtime performance (if any) caused by having 1000+ measures even if they not all referenced in the app...
Hi David, so if measures are not called in the application, then there should be 0 effect on performance - it just lives as metadata. That being said, it's still terrible practice - I mention in the video this is just a showcase. There is another external tool called the measure killer - which can be used to remove measures that are not referenced, and could be used to great effect here. I hope this helps :)
@@PowerBIPark Agreed but this is OK as a way to keep a library of scripts in one file for future reference as one learns DAX...Great Video!!!
Great video. I would request yo u to please make video on showing how to use shape map with geojason file. you can use the geojason of indian states( india), cause it is really frustrating to see that why powerbi don't read geojason file as they promise.
Hey ill put it in my suggestion box
Came here after watching ur post on LinkedIn
Thank you Siddiq, I hope this is useful to you
This is amazing but i had a problem with the Bravo in Time Intelligence tab date table and financial tables are not appearing any particular reason for that?
Hey, so I'm not sure exactly what's happening, but are you using the same data as in the video?
@@PowerBIPark yes for confirmation I use a different dataset and then tried with bravo and it actually worked but showing the same results for all the time intelligence functions. I didn't exactly know what is the reason behind this
Thank you for this great content! Is bravo now released? Free or paid?
Bravo is released and it's free. Just use the link in the description and usually should be okay :)
GREAT THIS VIDEO
Thanks!
This is a very good and useful video. I just have a question how can I add the Vertipaq analyzer ribbon on my excel ?
Hey thanks for the question you can either Google vertipaq analyzer download or select the link in my description. It's an excel addin, so it means you need to use the specific excel file from the link. Hope it helps!
Great keep it up.
Thanks Saad Masood
is there a way I can create this but by only having one value of columns and create those measures based on the rows as we do using the calculate function?
I know what you mean, technically you could use excel to generate code for doing this. I don't think tabular editor can generate code in this way, but I've used rows in excel and generating the scripts line by line before - it totally works and I've changed 1000+ measures this way by simply using excel formulas and substituting cells into the formula text
Does that help? :)
Very useful
Awesome...thanks
Thanks Adarsh! I hope the content is valuable to you
How do you open the VPAX file in Excel after saving it to our desktop? When I open the file it goes back to DAX Studio.
In the description, there's a download link to an excel file. You can access the VPAX through an extension they have. It's from the SQLBI website :)
@@PowerBIPark I downloaded the VPAX but my Excel is blocking the macros, the source of the file is untrusted.
thanks Injae!
Thanks for checking out the video Filip :)
Sir, is there any way of connecting tabular editor with chatgpt so it can read all measures, and give detailed explanation for all of them in one go?
Technically there's a couple of ways, such as using notable, code interpreter, or even google sheets. I don't have a video on this yet, but I will consider making one soon
Fantastic
Thank you!
Is it possible to request the sample dataset to practically walkthrough the video?
Hi Deepak, the dataset used is the sample data that is in every power bi desktop. If you follow the same steps in the video, you should be able to generate the same data yourself. Hope it helps!
@@PowerBIPark Very helpful. Any tip on working with DAX is fantastic.
Thankyou
I hope this is useful to you
Bravo Time Intelligence steps don't work. On clicking preview, nothing is showing under Time Intelligence
Wow ..
I hope this was something new and useful for you :)
@@PowerBIPark Its definitely new for me ....
This is not the best way to do this, sorry. You would be better off using calculation groups - one calc group for each aggregation type (avg, max, min,etc...), and another calc group for Time Intelligence (MTD, QTD, YTD, PY, etc..). The way you're doing it makes for a horrendous data model. Calculation groups are much cleaner and keep the model trim. It is all done in the software you are using as well, Tabular Editor. Anyone who reads this, I would highly recommend you research calculation groups instead of doing it this way.
Hi Kass, thanks for the comment, I do say the same thing explicitly in the video 😅😅 I'm working on a video about calculation groups, maybe that will be more what you'd like to see 👍
Hi Power Bi Park, thanks for the video: showcase on what external tools can do for beginners.
@kaas, thanks for your observations too, kindly link up with park to start a joint series!
Great video.. Smile bro..:)
Thanks man
This is amazing! Thank you!
Just awesome ! Many thanks