Make 1000+ DAX MEASURES in 10 MINS

No video

Make 1000+ DAX MEASURES in 10 MINS

Рет қаралды 32,639

Power BI Park

Күн бұрын

Пікірлер: 135

@UlyssesHaq Жыл бұрын

What an impressive start to your PoeerBI youtube series! Amazing, thank you for sharing! Looking forward to more of your content!

@PowerBIPark Жыл бұрын

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

@cbaide100 Жыл бұрын

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!

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

@muhammadasim8873 Жыл бұрын

Impressed... Subscribed... and hit the bell Icon for all notification... Wonderful bro... keep growing...

@KaterinaSarkisian 2 ай бұрын

Awsome, I didn't know for Bravo that can be used for external tools. Thanks for sharing with us 😊

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

@Cloudsofa 10 ай бұрын

this is the best thing I ever seen so far on youtube today...

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

@seyiabayomi 2 жыл бұрын

Great video with simple steps. Looking forward to seeing more videos using external tools.

@PowerBIPark 2 жыл бұрын

Thanks David!

@EricaDyson Жыл бұрын

Nothing short of excellent. So so useful, great presentation. THANKS SO MUCH!

@PowerBIPark Жыл бұрын

Thanks for the feedback Erica, I hope this is useful to you! :)

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

@ronaldtindoy6544 Жыл бұрын

Great video and nice to know about Bravo, Dax Studio, and Tabular

@PowerBIPark Жыл бұрын

Thanks Ronald! I hope you try some of these out yourself if you haven't already :)

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

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

@victorumoren8960 Жыл бұрын

Very informative video. Can't wait to try out these tips! Thanks a lot.

@AHMEDALDAFAAE1 11 ай бұрын

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 11 ай бұрын

It's not business useful directly, but still hopefully something that can be valuable for you in the future :)

@hulltrueblue 11 ай бұрын

Great video to showcase what you can do with these tools. Thank you ! keep up the good work. Now subscribed 😊

@PowerBIPark 11 ай бұрын

Awesome, thank you!

@crocoalex Жыл бұрын

Great video , it opens a new way for thinking , really good job👌

@PowerBIPark Жыл бұрын

Thanks Mohamed, I hope you get to use bravo as well 👍

@pablomora7880 11 ай бұрын

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.

@manarzamrik3978 Жыл бұрын

I appreciate you saving me a ton of time with this

@nikolagrkovic8769 Жыл бұрын

You just got a new subscriber. Excellent work!

@PowerBIPark Жыл бұрын

Thanks, I appreciate it 😁

@wtpro2232 Жыл бұрын

Great Job Injun

@manlikeMrA 2 жыл бұрын

This is great content. Looking forward to more of your videos

@PowerBIPark 2 жыл бұрын

Thanks for the feedback. More to come!

@tashagrihma6052 Жыл бұрын

A video on calculation groups would be great

@PowerBIPark Жыл бұрын

I promise you'll see that in my 3rd video :)

@phoenixoo7 Жыл бұрын

Started with a bang... Good one bro...

@PowerBIPark Жыл бұрын

Thanks man, next one will hopefully wow you just as much

@unnikrishnansanthosh Жыл бұрын

crystal clear explanation, thanks a lot

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

@experience_kingsley Жыл бұрын

What an interesting, well put together video. I learned a lot! Thanks!

@PowerBIPark Жыл бұрын

Glad to hear it!

@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

@martinmefril6496 Жыл бұрын

Awesome!! Can't wait for next videos

@PowerBIPark Жыл бұрын

Thanks Martin! :)

@rakeshmahakud110 5 ай бұрын

This is Brilliant

@sunilpardeshi1949 Жыл бұрын

Great nicely explained cam i use in real scenario

@franciscoencarnaciontavare2164 Жыл бұрын

Amazing! Thanks a lot! Great start 👏👏👏

@PowerBIPark Жыл бұрын

Thanks Francisco!

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

@mshparber Жыл бұрын

Brilliant!

@don_johnson_vice Жыл бұрын

Great content! Subscribed

@heeby89 9 күн бұрын

Whoa!

@nataliiaiatsenko7779 Жыл бұрын

Fantastic! Thank you!

@Brothercole1994 Жыл бұрын

This was amazing - thank you

@jamesrosicky2912 Жыл бұрын

This is amazing! Thank you!

@abdulrazakabdulkarim7698 Жыл бұрын

Wonderful video, welldone

@kdausu90 Жыл бұрын

Awesome stuff. Thank you!

@PowerBIPark Жыл бұрын

Thanks for the feedback Kaden!

@allabout1135 Жыл бұрын

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.

@Khan-mc3gi Жыл бұрын

Very useful its alot time saver👍

@siddiqshaik4072 Жыл бұрын

Came here after watching ur post on LinkedIn

@PowerBIPark Жыл бұрын

Thank you Siddiq, I hope this is useful to you

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

@tinaflemons263 Жыл бұрын

Fantastic job, thanks for sharing

@PowerBIPark Жыл бұрын

Thanks for watching!

@sarveshdeshpande1772 Жыл бұрын

That's cool ... I like the Bravo 👍👍

@PowerBIPark Жыл бұрын

Thanks Sarvesh! I like it too :)

@PaulBailey3 Жыл бұрын

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 Жыл бұрын

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!

@real1flame59 Жыл бұрын

Very nice video. Love it. Can the external tools perform “weighted average” ?

@PowerBIPark Жыл бұрын

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

@vicenteantoniomagallanesju5289 2 жыл бұрын

GREAT THIS VIDEO

@PowerBIPark 2 жыл бұрын

Thanks!

@alexrosen8762 Жыл бұрын

Very useful

@tadegbayi 3 ай бұрын

Thank you for this great content! Is bravo now released? Free or paid?

@PowerBIPark 3 ай бұрын

Bravo is released and it's free. Just use the link in the description and usually should be okay :)

@Khan-mc3gi Жыл бұрын

U should cover that type of dax in power bi which mostly use in sql during practical work

@Filip.S. Жыл бұрын

thanks Injae!

@PowerBIPark Жыл бұрын

Thanks for checking out the video Filip :)

@AhmedKhodir-novyPro Жыл бұрын

Awesome video !

@PowerBIPark Жыл бұрын

Thanks Ahmed!

@adarshshukla1961 Жыл бұрын

Awesome...thanks

@PowerBIPark Жыл бұрын

Thanks Adarsh! I hope the content is valuable to you

@Big38___ 6 ай бұрын

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 6 ай бұрын

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

@AmarShah76 Жыл бұрын

Bravo Time Intelligence steps don't work. On clicking preview, nothing is showing under Time Intelligence

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

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

@luisfernandomacedo1451 11 ай бұрын

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 11 ай бұрын

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

@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

@saadmasood7653 Жыл бұрын

Great keep it up.

@PowerBIPark Жыл бұрын

Thanks Saad Masood

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

@pavankumar-hw6zb Жыл бұрын

Thankyou

@PowerBIPark Жыл бұрын

I hope this is useful to you

@TheStormbreaker_SN Жыл бұрын

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 Жыл бұрын

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!

@veejay3626 10 ай бұрын

Just awesome ! Many thanks

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

@PedroCabraldaCamara 2 жыл бұрын

Fantastic

@PowerBIPark 2 жыл бұрын

Thank you!

@DeepakChauhan-mn5jw Жыл бұрын

Is it possible to request the sample dataset to practically walkthrough the video?

@PowerBIPark Жыл бұрын

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 Жыл бұрын

@@PowerBIPark Very helpful. Any tip on working with DAX is fantastic.

@jitendratrivedi7889 2 жыл бұрын

Wow ..

@PowerBIPark 2 жыл бұрын

I hope this was something new and useful for you :)

@jitendratrivedi7889 2 жыл бұрын

@@PowerBIPark Its definitely new for me ....

@kaas347 Жыл бұрын

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 Жыл бұрын

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 Жыл бұрын

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!