How to Bulk Edit Measures in Power BI - With Excel Template
HTML-код
- Опубликовано: 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!
Love your work, mate!
Much appreciated!
Thank you for your wonderful gift.
I hope you find some use for it :)
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