How to Bulk Edit Measures in Power BI - With Excel Template
Вставка
- Опубліковано 8 лип 2024
- This is a free Template to help you deal with a large number of Measures
0:00 - Intro
1:43 - Extract Measures
4:57 - Using the Template
10:16 - Formatting Measures
=================================
🔥The Template: github.com/PowerBIPark/Advanc...
🔥Tabular editor : docs.tabulareditor.com/
🔥Advanced Scripting: docs.tabulareditor.com/te2/Us...
🔥Bravo: bravo.bi/
🔥Vertipaq analyzer: www.sqlbi.com/tools/vertipaq-...
🔥Dax Studio : daxstudio.org/
=================================
Come find me on Linkedin: / injae-park
Thanks for taking the time to watch this video.
#powerbi #externaltools - Наука та технологія
This will be really helpful! Appreciate it!
Thank you for your wonderful gift.
I hope you find some use for it :)
Love your work, mate!
Much appreciated!
Awesome.
Glad you liked it! Hopefully it saves you some hours sometime
Muchas gracias Injae!
DeNada!
The IBCS charts you did are great. Assuming we want to create 2 or more charts with various columns such as sales, quantity and inventory (comparing to past year for all of them). Would you need to create 60x 3 measures to accomplish this ? Perhaps you could do a video on how to create 3 IBCS charts with different columns as references. I would like to use the chart across all my reports but it’s not intuitive to me how I can replicate the code across multiple columns.
Hi Jakob, this is such a great question. So in the IBCS, there are 3 main measures being used: _AC, _PY, _FC. The others are essentially just referencing those. So the easiest way to reuse things would be to use a field parameter or a switch measure and reference a specific measure in these 3 "base" measures. Field parameters are a bit more tricky because you need to use a workaround (you can't use selectedvalue() to reference the selection), but it would still work quite nicely :) Then you can just copy and paste the visual, and point the base measures to different ones, and you won't have to remake the visual