Calculation Groups (with Kane Snyder)

Рет қаралды 15,867

3 жыл бұрын

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

Пікірлер: 53

@ZachRenwickData 3 жыл бұрын

Thanks for demoing some other calculation group use cases! Glad to see you went beyond the obvious time intelligence uses.

@joaorataoo 3 жыл бұрын

Excellent. Thank you so much for sharing. Now I feel more comfortable being able to use it.

@DeronHuskey Жыл бұрын

Great, practical examples. Thanks to Reid and Kane.

@businessinsights_AlexRobe 3 жыл бұрын

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

@HavensConsulting 3 жыл бұрын

Our pleasure!

@tomchelle1 2 жыл бұрын

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!

@HavensConsulting 2 жыл бұрын

Glad you found it so informative! I’ll pass the info along to Ed 🙂

@isidrebague3659 2 жыл бұрын

Thank you very much for this incredible video. An excellent way to show the power of Calculated Groups. Congratulations Kane and Reid !!

@BernatAgulloRosello 3 жыл бұрын

Awesome video, thank you so much

@mnowako 3 жыл бұрын

Very useful tricks and good explanation. Thank you for sharing.

@erickknackstedt3131 3 жыл бұрын

This is so useful. Thank you both!

@lisadbrooks 2 жыл бұрын

Great walk-through, thank you!

@RodrigoGosling 3 жыл бұрын

Thank you very much for this video. I was looking for this solution for a long time :)

@janschroeven333 3 жыл бұрын

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

@jonathandiclementi5278 3 жыл бұрын

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.

@kanesnyder8964 3 жыл бұрын

You can add a blank measure by using BLANK() in the calculation item.

@venkateshns2003 3 жыл бұрын

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?

@BernatAgulloRosello 3 жыл бұрын

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.

@HavensConsulting 3 жыл бұрын

I’d recommend asking Kane directly on Twitter about this 🙂

@cparedes2302 3 жыл бұрын

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?

@HavensConsulting 3 жыл бұрын

When you install an external tool (tabular editor, Dax studio, etc) it’ll then show up on the external tools in Power BI 🙂

@raghun2636 2 жыл бұрын

calculation groups when drilling through are not filtering dates in the target reports

@zxccxz164 3 жыл бұрын

Any discussion on Power BI RS? What does that group of users get to use?

@HavensConsulting 3 жыл бұрын

Do you mean RLS? Could you elaborate a bit on this question

@lokeshtuteja3108 2 жыл бұрын

One thing regarding calculation group can we sort the matrix from high value to low value and vice-versa on any particular column.

@HavensConsulting 2 жыл бұрын

With calc groups and the native matrix you can't sadly. However advanced custom matrix visual like InfoRiver do it very easily. :)

@lokeshtuteja3108 2 жыл бұрын

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

@felixthecatx887 2 жыл бұрын

This is crazy! Does this mean you can have labels return other values (even text or categorical) while displaying numbers generated from measures?

@HavensConsulting 2 жыл бұрын

It does! Here's a link to another video that shows this kzfaq.info/get/bejne/pbl8jJx0sL7GgKM.html

@BernatAgulloRosello 3 жыл бұрын

In excel you can put some colors (by name!) in format string. Has anybody tried if that works in powerbi?

@HavensConsulting 3 жыл бұрын

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 🙂

@BernatAgulloRosello 3 жыл бұрын

Well but then you can use that in calculation groups for format string which is nice for some use cases

@BernatAgulloRosello 3 жыл бұрын

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.

@BernatAgulloRosello 3 жыл бұрын

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

@HavensConsulting 3 жыл бұрын

@@BernatAgulloRosello that sounds like something you should blog about :)

@zxccxz164 3 жыл бұрын

hi where is the file you promise in the video? i wondering the links and can't find it.

@zxccxz164 3 жыл бұрын

try putting calculated groups in your website......takes to blank page of seattle

@HavensConsulting 3 жыл бұрын

Not sure I follow? Where did you put "calculated groups"? The location for the files is here: www.havensconsulting.net/blog-files

@zxccxz164 3 жыл бұрын

@@HavensConsulting I your search box for Search Blogs. The link you sent above wants a password

@HavensConsulting 3 жыл бұрын

@@zxccxz164 it does. If you sign up for the blog (free to sign up). You'll be sent a welcome email with the password :)

@annkrause9325 2 жыл бұрын

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?

@jeffweir9358 3 жыл бұрын

Damn this is clever.

@HavensConsulting 3 жыл бұрын

I was in awe a lot of it! Definitely learned some really clever stuff!

@pauladeniyi5876 Жыл бұрын

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.

@HavensConsulting Жыл бұрын

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