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.
@PowerBIPark
Жыл бұрын
Thanks for the feedback Carlos, I'm glad this was useful to you!
@muhammadasim8873
Жыл бұрын
Impressed... Subscribed... and hit the bell Icon for all notification... Wonderful bro... keep growing...
@UlyssesHaq
2 жыл бұрын
What an impressive start to your PoeerBI youtube series! Amazing, thank you for sharing! Looking forward to more of your content!
@PowerBIPark
2 жыл бұрын
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 :)
@AmarShah76
Жыл бұрын
Bravo Time Intelligence steps don't work. On clicking preview, nothing is showing under Time Intelligence
@mshparber
Жыл бұрын
Brilliant!
@michaelkane8789
Жыл бұрын
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
@PowerBIPark
Жыл бұрын
Im really glad that you found this useful 😁 thanks for the feedback!
@seyiabayomi
2 жыл бұрын
Great video with simple steps. Looking forward to seeing more videos using external tools.
@PowerBIPark
2 жыл бұрын
Thanks David!
@johnuzoma1823
2 жыл бұрын
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.
@PowerBIPark
2 жыл бұрын
Thanks for the feedback John!
@tashagrihma6052
2 жыл бұрын
A video on calculation groups would be great
@PowerBIPark
2 жыл бұрын
I promise you'll see that in my 3rd video :)
@zubair242
2 жыл бұрын
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.
@PowerBIPark
2 жыл бұрын
Hey I'll definitely have this in mind, thanks for the suggestion.
@EricaDyson
2 жыл бұрын
Nothing short of excellent. So so useful, great presentation. THANKS SO MUCH!
@PowerBIPark
2 жыл бұрын
Thanks for the feedback Erica, I hope this is useful to you! :)
@sunilpardeshi1949
Жыл бұрын
Great nicely explained cam i use in real scenario
@vishalraj8902
Ай бұрын
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.
@PowerBIPark
Ай бұрын
Hey ill put it in my suggestion box
@victorumoren8960
Жыл бұрын
Very informative video. Can't wait to try out these tips! Thanks a lot.
@allabout1135
2 жыл бұрын
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.
@PowerBIPark
Жыл бұрын
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.
@smith9808
Жыл бұрын
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!!
@PowerBIPark
Жыл бұрын
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 😁
@tadegbayi
4 ай бұрын
Thank you for this great content! Is bravo now released? Free or paid?
@PowerBIPark
4 ай бұрын
Bravo is released and it's free. Just use the link in the description and usually should be okay :)
@PaulBailey3
2 жыл бұрын
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...
@PowerBIPark
2 жыл бұрын
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!
@rakeshmahakud110
6 ай бұрын
This is Brilliant
@don_johnson_vice
Жыл бұрын
Great content! Subscribed
@luisfernandomacedo1451
Жыл бұрын
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?
@PowerBIPark
Жыл бұрын
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
@diwakarchaurasia
Жыл бұрын
Great stuff about powerbi.... looking forward for more such interesting stuff 👍 😀
@PowerBIPark
Жыл бұрын
Thanks Diwakar, I hope that my content becomes something that gives you value in your own projects :)
@wtpro2232
Жыл бұрын
Great Job Injun
@unnikrishnansanthosh
Жыл бұрын
crystal clear explanation, thanks a lot
@pietroizzo5209
Жыл бұрын
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?
@PowerBIPark
Жыл бұрын
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? :)
@HakeemLawrence
2 жыл бұрын
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.
@PowerBIPark
2 жыл бұрын
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 :)
@nataliiaiatsenko7779
Жыл бұрын
Fantastic! Thank you!
@abdulrazakabdulkarim7698
2 жыл бұрын
Wonderful video, welldone
@real1flame59
2 жыл бұрын
Very nice video. Love it. Can the external tools perform “weighted average” ?
@PowerBIPark
2 жыл бұрын
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
@alexrosen8762
Жыл бұрын
Very useful
@benignoguilarte2806
Жыл бұрын
This is just an amazing video and also really great explanation. I am a new Fan 👌
@PowerBIPark
Жыл бұрын
Thanks man, I've been putting off uploading new content for a bit but comments like yours really motivate me to get back in ☺
@Brothercole1994
Жыл бұрын
This was amazing - thank you
@KaterinaSarkisian
3 ай бұрын
Awsome, I didn't know for Bravo that can be used for external tools. Thanks for sharing with us 😊
@siddiqshaik4072
2 жыл бұрын
Came here after watching ur post on LinkedIn
@PowerBIPark
2 жыл бұрын
Thank you Siddiq, I hope this is useful to you
@ronaldtindoy6544
2 жыл бұрын
Great video and nice to know about Bravo, Dax Studio, and Tabular
@PowerBIPark
2 жыл бұрын
Thanks Ronald! I hope you try some of these out yourself if you haven't already :)
@DavidPesante
Жыл бұрын
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...
@PowerBIPark
Жыл бұрын
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 :)
@apamwamba
Жыл бұрын
@@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!!!
@bharathsaikumar5519
Жыл бұрын
Awesome.....how to download tabular editor and bravo connect with power bi? ..can you please explain.?
@PowerBIPark
Жыл бұрын
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! 😊
@bharathsaikumar5519
Жыл бұрын
@@PowerBIPark thank you so much..
@jamesrosicky2912
Жыл бұрын
This is amazing! Thank you!
@veejay3626
11 ай бұрын
Just awesome ! Many thanks
@crocoalex
2 жыл бұрын
Great video , it opens a new way for thinking , really good job👌
@PowerBIPark
2 жыл бұрын
Thanks Mohamed, I hope you get to use bravo as well 👍
@Khan-mc3gi
Жыл бұрын
U should cover that type of dax in power bi which mostly use in sql during practical work
@TheRobarbie
Жыл бұрын
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.
@PowerBIPark
Жыл бұрын
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 :)
@TheRobarbie
Жыл бұрын
@@PowerBIPark I downloaded the VPAX but my Excel is blocking the macros, the source of the file is untrusted.
@manlikeMrA
2 жыл бұрын
This is great content. Looking forward to more of your videos
@PowerBIPark
2 жыл бұрын
Thanks for the feedback. More to come!
@pablomora7880
Жыл бұрын
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.
@franciscoencarnaciontavare2164
2 жыл бұрын
Amazing! Thanks a lot! Great start 👏👏👏
@PowerBIPark
2 жыл бұрын
Thanks Francisco!
@KedielSanchezMariano
Жыл бұрын
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!!!!!
@syedasherahmed949
Жыл бұрын
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
Жыл бұрын
Hey, so I'm not sure exactly what's happening, but are you using the same data as in the video?
@syedasherahmed949
Жыл бұрын
@@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
@kdausu90
2 жыл бұрын
Awesome stuff. Thank you!
@PowerBIPark
2 жыл бұрын
Thanks for the feedback Kaden!
@vicenteantoniomagallanesju5289
2 жыл бұрын
GREAT THIS VIDEO
@PowerBIPark
2 жыл бұрын
Thanks!
@Cloudsofa
11 ай бұрын
this is the best thing I ever seen so far on youtube today...
@AHMEDALDAFAAE1
Жыл бұрын
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
Жыл бұрын
It's not business useful directly, but still hopefully something that can be valuable for you in the future :)
@erikgrotensteenwelle8178
2 жыл бұрын
Good, keep on the good work, looking forward to next vid
@PowerBIPark
2 жыл бұрын
Thanks Erik! Any topics that you'd particularly like to see?
@erikgrotensteenwelle8178
2 жыл бұрын
@@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
@manarzamrik3978
Жыл бұрын
I appreciate you saving me a ton of time with this
@adarshshukla1961
2 жыл бұрын
Awesome...thanks
@PowerBIPark
2 жыл бұрын
Thanks Adarsh! I hope the content is valuable to you
@Khan-mc3gi
Жыл бұрын
Very useful its alot time saver👍
@Filip.S.
2 жыл бұрын
thanks Injae!
@PowerBIPark
2 жыл бұрын
Thanks for checking out the video Filip :)
@TheStormbreaker_SN
2 жыл бұрын
This is a very good and useful video. I just have a question how can I add the Vertipaq analyzer ribbon on my excel ?
@PowerBIPark
2 жыл бұрын
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!
@pavankumar-hw6zb
2 жыл бұрын
Thankyou
@PowerBIPark
2 жыл бұрын
I hope this is useful to you
@hulltrueblue
Жыл бұрын
Great video to showcase what you can do with these tools. Thank you ! keep up the good work. Now subscribed 😊
@PowerBIPark
Жыл бұрын
Awesome, thank you!
@nikolagrkovic8769
Жыл бұрын
You just got a new subscriber. Excellent work!
@PowerBIPark
Жыл бұрын
Thanks, I appreciate it 😁
@Big38___
7 ай бұрын
Hi Park, every time i hit the run key for the script, the new measures replace the original KPIs. any reason why it keeps doing that way?
@PowerBIPark
7 ай бұрын
Hey, they do that by design, because the measure name is the same. You need a new measure name if you want it to make a new measure
@experience_kingsley
Жыл бұрын
What an interesting, well put together video. I learned a lot! Thanks!
@PowerBIPark
Жыл бұрын
Glad to hear it!
@lucmpangaje8727
Жыл бұрын
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 🙏🏽
@PowerBIPark
Жыл бұрын
Glad it was helpful!
@kaas347
2 жыл бұрын
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.
@PowerBIPark
2 жыл бұрын
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 👍
@jibbieodutola
2 жыл бұрын
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!
@martinmefril6496
2 жыл бұрын
Awesome!! Can't wait for next videos
@PowerBIPark
2 жыл бұрын
Thanks Martin! :)
@sarveshdeshpande1772
2 жыл бұрын
That's cool ... I like the Bravo 👍👍
@PowerBIPark
2 жыл бұрын
Thanks Sarvesh! I like it too :)
@DeepakChauhan-mn5jw
2 жыл бұрын
Is it possible to request the sample dataset to practically walkthrough the video?
@PowerBIPark
2 жыл бұрын
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!
@DeepakChauhan-mn5jw
2 жыл бұрын
@@PowerBIPark Very helpful. Any tip on working with DAX is fantastic.
@tinaflemons263
Жыл бұрын
Fantastic job, thanks for sharing
@PowerBIPark
Жыл бұрын
Thanks for watching!
@phoenixoo7
2 жыл бұрын
Started with a bang... Good one bro...
@PowerBIPark
2 жыл бұрын
Thanks man, next one will hopefully wow you just as much
@saadmasood7653
2 жыл бұрын
Great keep it up.
@PowerBIPark
2 жыл бұрын
Thanks Saad Masood
@AhmedKhodir-novyPro
2 жыл бұрын
Awesome video !
@PowerBIPark
2 жыл бұрын
Thanks Ahmed!
@PedroCabraldaCamara
2 жыл бұрын
Fantastic
@PowerBIPark
2 жыл бұрын
Thank you!
@jitendratrivedi7889
2 жыл бұрын
Wow ..
@PowerBIPark
2 жыл бұрын
I hope this was something new and useful for you :)
Пікірлер: 137