Это видео недоступно.
Сожалеем об этом.
Calculation Groups (with Kane Snyder)
HTML-код
- Опубликовано: 15 фев 2021
- Hang out with us as Kane Snyder walks us through many creative and incredibly useful ways to utilize calculation groups when developing models in Power BI Desktop!
RELATED CONTENT 🔗
Kane's Blog -- / tenfingers
Kane's Twitter -- / tenfingers
Calculation Groups Article -- www.sqlbi.com/calculation-groups
LET'S CONNECT! 🧑🏽🤝🧑🏽 🌟
-- / havensbi
-- / reidhavens
-- / havensconsulting
VIDEO CHAPTERS 🎥
0:13 - Start of Discussion
10:00 - Start of Demo
HAVENS CONSULTING PAGES 📄
Home Page -- www.havensconsulting.net
Blog -- www.havensconsulting.net/blog-...
Blog Files -- www.havensconsulting.net/blog-...
Files & Templates -- www.havensconsulting.net/files...
Consulting Services -- www.havensconsulting.net/consu...
Online Course -- www.havensconsulting.net/onli...
Contact & Support -- www.havensconsulting.net/conta...
EMAIL US AT 📧
info@havensconsulting.net
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #dax #sqlbi #calculationgroups
Thanks for demoing some other calculation group use cases! Glad to see you went beyond the obvious time intelligence uses.
Guys, thank you so much for your highly illustrative practical examples finally motivating me to leave the known comfort zone of the measures-only universe.
For me already the video of the month! 👍
Our pleasure!
Great, practical examples. Thanks to Reid and Kane.
I watched this vid when it first came out and have been coming back to it ever since. Probably my most frequently referenced tech videos on youtube. Kudos gentlemen!
Glad you found it so informative! I’ll pass the info along to Ed 🙂
Very useful tricks and good explanation. Thank you for sharing.
Thank you very much for this incredible video. An excellent way to show the power of Calculated Groups.
Congratulations Kane and Reid !!
Excellent.
Thank you so much for sharing.
Now I feel more comfortable being able to use it.
Awesome video, thank you so much
This is so useful. Thank you both!
Thank you very much for this video. I was looking for this solution for a long time :)
Great walk-through, thank you!
I am using this calculation group. this is very helpful. I am facing a problem when i export it from power bi service. the problem is - I see the measures like CY,PY,YoY,YoY% CY reach% to PY in columns in the visuals, but when i export this to an excel then these measures are not exported as columns but they are turned into rows and also changes the number formats from %s to numbers. Can you please let me know if you have a solution for this?
Great video!
Too bad if you use the blank space the tooltips also doesn't return anything for the value.
I also hope they will introduce conditional formatting one day.
When it is possible, we could instead of putting a blank space, we could use the last 2 digits of the HEX code to make the labels transparant, but still keep the tooltip values
thanks for this video. do you have an example of using two calculation groups against each other with a blank measure in the middle? I'm trying to build similar to what you're describing at 29:00. the goal is to have calculations that work for different time periods 10-year, 5-year, etc with various return metrics calculated from those horizon periods.
You can add a blank measure by using BLANK() in the calculation item.
calculation groups when drilling through are not filtering dates in the target reports
Many thanks... I am new at Power BI and I feel embarrassed but my Desktop Program does not show the External Tools tab...
Any suggestions to have shown?
When you install an external tool (tabular editor, Dax studio, etc) it’ll then show up on the external tools in Power BI 🙂
Wait, but if you use conditional formatting using the color returned by a measure you can check in which column you are and do the conditional formatting you need right? Quite tough coding but should work, at least in my head.
I’d recommend asking Kane directly on Twitter about this 🙂
Any discussion on Power BI RS? What does that group of users get to use?
Do you mean RLS? Could you elaborate a bit on this question
This is crazy! Does this mean you can have labels return other values (even text or categorical) while displaying numbers generated from measures?
It does! Here's a link to another video that shows this ruclips.net/video/oSLY9CKXbPo/видео.html
hi where is the file you promise in the video? i wondering the links and can't find it.
try putting calculated groups in your website......takes to blank page of seattle
Not sure I follow? Where did you put "calculated groups"? The location for the files is here: www.havensconsulting.net/blog-files
@@HavensConsulting I your search box for Search Blogs. The link you sent above wants a password
@@zxccxz164 it does. If you sign up for the blog (free to sign up). You'll be sent a welcome email with the password :)
I signed up for your blog, but it didn't give me a password ... all it asked me to do was confirm my email address. How do I get the file without a password?
One thing regarding calculation group can we sort the matrix from high value to low value and vice-versa on any particular column.
With calc groups and the native matrix you can't sadly. However advanced custom matrix visual like InfoRiver do it very easily. :)
@@HavensConsulting thank you for your input. FYI i am able to find a way but not sure whether it the right approach here or not.
Thanks for this great tutorial, but pls can I get the file for the tutorial? I couldn't get the required password even after subscribing to the blog.
Hi Paul, I just checked MailChimp and I didn't see a sign up for Paul Adeniyi. It's a double opt-in so the first time you sign up from my website you'll need to click confirm in the opt-in email, before you're sent the welcome email with the Blog Files page password
Damn this is clever.
I was in awe a lot of it! Definitely learned some really clever stuff!
In excel you can put some colors (by name!) in format string. Has anybody tried if that works in powerbi?
You can, but it’s usually a much smaller subset of colors! Versus the HEX code. I like to make my hex codes in VAR’s. Gives a similar effect 🙂
Well but then you can use that in calculation groups for format string which is nice for some use cases
I don't know if there's any way to refer to theme colors from dax instead of just putting the hex code. That would make it easier to mantain. Otherwise maybe storing hex codes in string measures to use througout the report and have them centralized.
It does not work in powerbi. I managed to get the hex values of the theme by loading the json fine as a data source and then batch creating measures with tabular editor
@@BernatAgulloRosello that sounds like something you should blog about :)
Actually it’s syntactic sugar. It’s an adjective. 😎
SQLBI does actually call it Syntax Sugar. They have a few articles with that phrase 😊 www.sqlbi.com/articles/the-in-operator-in-dax/