Use Measures as Columns Using Calculation Group in Power BI
Вставка
- Опубліковано 6 жов 2024
- 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/l...
✔️ Power Query Course-
goodly.co.in/l...
✔️ Master Excel Step by Step-
goodly.co.in/l...
✔️ Business Intelligence Dashboards-
goodly.co.in/l...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co....
Corporate Training 👨🏫 - www.goodly.co....
Need my help on a Project 💻- www.goodly.co....
Download File ⬇️ - goodly.co.in/h...
===== 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!
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.
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!!
A lot of BI goodness in 10 minutes! Thanks.
Glad you enjoyed it!
Absolutely. Agree. Mega thanks🎉
@@GoodlyChandeephow to get the "drill on-Columns" small check box where you changed from rows to columns can you please help?
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!
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?
💥Awesome application and clarity in explaining....... .......Goodly = GOLDLY !!
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)...
You are the best. We learn a lot from you.
Great explanation Goodly, thank you!!. would this measure as column behave the sane way if we do analyze in excel?
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!
This blew me of my feet! Wonderful. Thank you so much!
Glad you enjoyed it :)
Amazing video! Keep it up bro. Thanks
Did anyone face the issue of not getting the "drill on - Columns" option at all?
Even i didn't get it
me too @@ajay22111
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
like your explanation. Thanks!
Such a clever and powerful trick! thanks a lot for this :-)
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
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 ?
You need to use isinscope
can they be used in scorecards (or some other visual component), and how?
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.
I am considering Total Units, I need to show those products only where no blank data is present for selected quarter. How it can be achieved.
Awesome video Chandeep!
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.
@Goodly how to get the "Drill-On" columns ,anyone can you help please.
You need to have 2 fields in rows and 2 fields in columns
Can you please make a video for Moving Range. I can't figure out how to do it without using Verus Previous in Visual Calculations.
ua-cam.com/video/FLjygam5x-I/v-deo.html
It's great 👍 hope will use this in PBI desktop.
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?
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?
I got a bit confused at 7:15, where "KPI" suddenly shows up, where did you get this from?
it creates automaticaly
I am not getting "Drill On" option. How to get that?
Thank you BOSS!😊
Certainly the largest font size on the screen 😅
sir aap se request ki aap hindi main bhi video banao full course power bi ki
Good stuff!
Great again!
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.
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.
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
Boom🎉