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
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.
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 ?
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.
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
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 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.
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?
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
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.
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!!
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?
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)...
💥Awesome application and clarity in explaining....... .......Goodly = GOLDLY !!
This blew me of my feet! Wonderful. Thank you so much!
Glad you enjoyed it :)
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!
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?
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
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.
can they be used in scorecards (or some other visual component), and how?
Awesome video Chandeep!
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.
ruclips.net/video/FLjygam5x-I/видео.html
like your explanation. Thanks!
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 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.
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.
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
Such a clever and powerful trick! thanks a lot for this :-)
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
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?
Did anyone face the issue of not getting the "drill on - Columns" option at all?
Even i didn't get it
me too @@ajay22111
Thank you BOSS!😊
Certainly the largest font size on the screen 😅
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.
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.
Good stuff!
Great again!
I am not getting "Drill On" option. How to get that?
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?
I got a bit confused at 7:15, where "KPI" suddenly shows up, where did you get this from?
it creates automaticaly
It's great 👍 hope will use this in PBI desktop.
sir aap se request ki aap hindi main bhi video banao full course power bi ki
Boom🎉
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
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.