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.
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?
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!
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)...
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
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.
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.
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?
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 ?
I cannot get the Last Year value to work. I need it to pull the max datevalue in my data table since my date table is pulling partial months but my data tables is last full month. How can I modify this calculation for last year to look at the max date value and also only pull a total? Hopefully this makes sense.
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.
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?
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
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
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.
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?
The best session I found which explain vital function for finance forks.... Great thank you
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!!
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.
You are the best. We learn a lot from you.
Thank you for the video!
Is it possible to put measures LY, CY and so on, in the same level of months?
💥Awesome application and clarity in explaining....... .......Goodly = GOLDLY !!
This blew me of my feet! Wonderful. Thank you so much!
Glad you enjoyed it :)
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 video Chandeep!
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!
I got a bit confused at 7:15, where "KPI" suddenly shows up, where did you get this from?
it creates automaticaly
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!
like your explanation. Thanks!
Amazing video! Keep it up bro. Thanks
@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
Did anyone face the issue of not getting the "drill on - Columns" option at all?
Even i didn't get it
me too @@ajay22111
Such a clever and powerful trick! thanks a lot for this :-)
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)...
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
Good stuff!
Thank you BOSS!😊
Certainly the largest font size on the screen 😅
can they be used in scorecards (or some other visual component), and how?
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.
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.
th-cam.com/video/FLjygam5x-I/w-d-xo.html
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.
when I drill down, the calculated group column stays on the top of the second tier column. it does not popup at the end somehow.
Great again!
I am not getting "Drill On" option. How to get that?
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 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.
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
I cannot get the Last Year value to work. I need it to pull the max datevalue in my data table since my date table is pulling partial months but my data tables is last full month. How can I modify this calculation for last year to look at the max date value and also only pull a total? Hopefully this makes sense.
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.
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?
It's great 👍 hope will use this in PBI desktop.
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
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
sir aap se request ki aap hindi main bhi video banao full course power bi ki
Boom🎉
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.