Use Measures as Columns Using Calculation Group in Power BI

Рет қаралды 38,340

11 ай бұрын

In this tutorial, you'll learn how to use measures as columns in Power BI by using calculation groups. We will create a highly customized table visualization with columns representing various measures. We used Tabular Editor, an external tool, to create and manage calculation groups in Power BI.
===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co.in/blog/
Corporate Training 👨‍🏫 - www.goodly.co.in/training/
Need my help on a Project 💻- www.goodly.co.in/consulting/
Download File ⬇️ - goodly.co.in/how-to-use-measu...
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - goodly.wordpress@gmail.com
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!

Пікірлер: 43

@Milhouse77BS 11 ай бұрын

A lot of BI goodness in 10 minutes! Thanks.

@GoodlyChandeep 11 ай бұрын

Glad you enjoyed it!

@EricaDyson 11 ай бұрын

Absolutely. Agree. Mega thanks🎉

@ajay22111 3 ай бұрын

@@GoodlyChandeephow to get the "drill on-Columns" small check box where you changed from rows to columns can you please help?

@jahmed525 10 ай бұрын

This is Gold!!! I was totally scratching my head on how to do it in a Matrix instead of a flat table. Tabluar Editor for the win!!

@priyeshsanghvi8424 8 ай бұрын

💥Awesome application and clarity in explaining....... .......Goodly = GOLDLY !!

@BISimplifier 11 ай бұрын

Great . One thing i like very much you explain the base concept again (e:g:calculation group) for the complete new comer to understand the overall content well. This is well aligned with Alberto's calc presentation.

@vayani Ай бұрын

Amazing video! Keep it up bro. Thanks

@abtotheku 9 ай бұрын

You are the best. We learn a lot from you.

@jakes6639 10 ай бұрын

like your explanation. Thanks!

@chrisinbcn 6 ай бұрын

Hello Chandeep, great video as usual! Would you be so kind to share also the source of the sentiment symbol to put next to the measure in the formatting window? I am struggling as I don't know where to find it. Thank you!

@ajay22111 3 ай бұрын

@Goodly how to get the "Drill-On" columns ,anyone can you help please.

@chrism9037 10 ай бұрын

Awesome video Chandeep!

@olunugaoladipupo7058 10 ай бұрын

This blew me of my feet! Wonderful. Thank you so much!

@GoodlyChandeep 10 ай бұрын

Glad you enjoyed it :)

@etienneborella 11 ай бұрын

Such a clever and powerful trick! thanks a lot for this :-)

@JamesMazzanti 6 ай бұрын

Great video. I’m struggling with calculation groups as columns and calculation groups as rows at same time, I’ve experimented with precedence but no luck yet. Any videos of yours on this challenge?

@90hsilva 10 ай бұрын

Great explanation Goodly, thank you!!. would this measure as column behave the sane way if we do analyze in excel?

@arbazahmad7177 11 ай бұрын

It's great 👍 hope will use this in PBI desktop.

@Evaldas65 11 ай бұрын

This is a common requirement of my clients, going to experiment with this, thanks! Still, it's a bit odd that PowerBI doesn't support this kind of thing my default (custom measures in a matrix after totals)...

@oksanakiselova5470 7 ай бұрын

Hi, thank you for the video! It is really helpful! I would like to ask if it is possible to use another tool similar to Tabular Editor? Thank you!

@davidlaid-ur9xn 2 ай бұрын

What should be the DAX for calculation items, if we are not selecting the measures from the parameters , but instead we want to drag and drop the measures in the matrix visual

@sco77ybear 11 ай бұрын

Good stuff!

@RogerStocker 11 ай бұрын

Great again!

@vincenzonosso7400 3 ай бұрын

can they be used in scorecards (or some other visual component), and how?

@Rice8520 11 ай бұрын

Thank you BOSS!😊

@desigoodly 11 ай бұрын

Certainly the largest font size on the screen 😅

@viswanathanganesan738 8 ай бұрын

very clear presentation, i tried this for one of my use case but am not able to get the desired results. in my case i need to show product details as rows and have few measures of qty, price, margin with month year of stock availability. i used the same measures shown here but all my measures of qty, price and margin appear under each month. can u pls help advise ?

@kelechiuwamanze2823 11 ай бұрын

Great video always, I have a question though. We have different products (say 100 products) for which we review prices on different months according to market realities. For example, we could review prices for 90 products in October and the next review could be in February, but this time the review would be for 97 products. Now, how do I get the % difference between the sum of February prices and that of October?

@user-js9lw1ex1c 11 ай бұрын

Hi, thank you for sharing video. I have one problem if you can help me. I want to calculate product of quantity from current month and prices from previous month. I was able to get prices from prevous month usig function "previousmonth" but when I write formula: quantity*Price(previous month) I get correct result by custumers, but incorrect totals. When I try to use sumx (=sumx(Sales[sales ]*calculete(prices,previousmonth(Date[Date]), I get blanks values for all custumers. Do you know what is the problem?

@haroonmalik5565 10 ай бұрын

I have made a power query file in which I use one type of assembly out of 10 assemblies through the use of a filter. Later, when I have to make a separate copy of the file for another assembly, I have to manually change the filter at around 6 places. My question is, can I set a single place for the filtered assembly and call in the power queries from there? This way I will have to just change the filtered option once and all subsequent power queries will take that change automatically. I shall appreciate a quick response.

@AJAYKUMAR-vf4df 4 ай бұрын

sir aap se request ki aap hindi main bhi video banao full course power bi ki

@ArmanAper7 6 ай бұрын

Hi, thanks for your videos, they are amazing. Can you please, help to solve the problem with customized table I need to show YTD Amount in Matrix (up to selected Month) in one column and YTG Amounts by months (several columns). For example, if a user chooses 10th month, the matrix should show YTD (up to 10 th month in 1 st column than, 11 and 12 month separetely. Thanks in advance.

@mahathivucha4187 7 ай бұрын

Did anyone face the issue of not getting the "drill on - Columns" option at all?

@ajay22111 3 ай бұрын

Even i didn't get it

@thonysport 2 ай бұрын

me too @@ajay22111

@danishnawaz3651 3 ай бұрын

Plz make Video for below Formula "Power Query", Video Time Fram is Max 10mint 1. List.RemoveMatchingItems 2. List.ReplaceMatchingItems 3. List.TransformMany 4. List.ReplaceValue 5. List.PositionOfAny 6. List.PositionOf 7. List.NonNullCount 8. List.Intersect 9. List.Durations 10. List.Difference 11. List.FindText 12. List.InsertRange 13. List.Union

@dilip1able 11 ай бұрын

Boom🎉

@christiankurirandersen7766 9 ай бұрын

I got a bit confused at 7:15, where "KPI" suddenly shows up, where did you get this from?

@antongerasimov2298 6 ай бұрын

it creates automaticaly

@AgulloBernat 10 ай бұрын

The thumbnail of the video shows the calculation item names in line with the month names, that's not quite possible right? At least it's not the outcome of what you show in the video. You can rename the total, but would be the same name for all three columns

@AgulloBernat 10 ай бұрын

there's no need to format the selectedmeasure inside the formatstring expression most of the times (8:18) --- the result of the format string expression should be just a format string, not a formatted number, unless you want to override the number that the value expression returns.

@1yyymmmddd 11 ай бұрын

Cool DAX acrobatics, but calculation groups are pretty useless for me as you have no flexibility in there. For example if you need YTD and QTD in one visual, but QTD and YTD (reverse sequence) in another - you can not use same calculation group but need to create a new one, although with the same measures. So why use calculation groups when you can do it in PBI? Also, calculation groups are bad for code readability.