Have you played with Calculation Groups in Power BI yet? With the Oct 2023 Power BI update, now we can create calculation groups in Power BI Desktop itself (No more Tabular Editor).
BOOM !!! That's awesome !!! I think you use a really impressive method and manage to transform it simply and easily. Some questions my mind tricked me: in the MTD measures, I did not see a difference in the Current values. MTD should be an accumulative value month each month ? Because repeated all the values. --- Current | MTD Jan = 10 | 10 Fev = 15 | 25 --- In the QTD, 2013 10 did not sum (4,48 + 9,30) just repeated 9,30. In the QTD, 2013 11 did sum (9,30 + 7,27 = 16,56). --- In the 2014 values are accumulative on QTD measure OK. --- Thank you for all of your hard work, and for sharing with us !!! Keep going on this track.
Thanks for stopping by. "Calculation items" are not applied to implicit measures. Calculation items only apply to explicit measures. This is how "Calculation Groups" in Power BI has been designed. Also, explicit measures are more flexible in general.
Hi. Nestor i would like to make Cal. Group With Matrix Data, for Example like This Month and YTD dan next Level is Qty and Amount, please show me to make it happen thank you
Hey Amir, Thanks for stopping by. Based on what you described, this tutorial will definitely provide you with the details. You just need to create your explicit measures (Qty and Amount) and then create the calculation group for time intelligence calculation items. Cheers!
Huge update!! Great explanation
Agree 100%👍
Smartly Explained and swiftly understood 👍
Glad to hear that. Cheers!
By far the most comprehensive yet simplest explanation and examples I have come accross. Thanks so much for this!
Glad to hear that. Cheers!
Have you played with Calculation Groups in Power BI yet? With the Oct 2023 Power BI update, now we can create calculation groups in Power BI Desktop itself (No more Tabular Editor).
me suscribi, sos un grande!
Excelente. Saludos!
BOOM !!! That's awesome !!!
I think you use a really impressive method and manage to transform it simply and easily.
Some questions my mind tricked me:
in the MTD measures, I did not see a difference in the Current values.
MTD should be an accumulative value month each month ? Because repeated all the values.
---
Current | MTD
Jan = 10 | 10
Fev = 15 | 25
---
In the QTD, 2013 10 did not sum (4,48 + 9,30) just repeated 9,30.
In the QTD, 2013 11 did sum (9,30 + 7,27 = 16,56).
---
In the 2014 values are accumulative on QTD measure OK.
---
Thank you for all of your hard work, and for sharing with us !!!
Keep going on this track.
That's interesting! I have never seen that before. Make sure the DAX measures are correctly written.
Nestor, boom! Nice video thank you
Glad you found this helpful. Cheers!
Great tutorial about a great function 👏
Glad to hear that. Cheers!
Good Job!!
Glad to hear that. Cheers!
Muy interesante Nestor. Muchas gracias.
You bet!
Also, I haven’t seen your comments in a while. Glad you are back 👍
Gracias por compartir
Gracias por revisar el contenido, Raúl. Saludos 👍
can they be used in scorecards (or some other visual component), and how?
What's the compromise in respect of implicit measures and permitting end users to add measures to a report based on the underlying model?
Thanks for stopping by. "Calculation items" are not applied to implicit measures. Calculation items only apply to explicit measures. This is how "Calculation Groups" in Power BI has been designed. Also, explicit measures are more flexible in general.
Hi. Nestor
i would like to make Cal. Group With Matrix Data, for Example like This Month and YTD dan next Level is Qty and Amount, please show me to make it happen
thank you
Hey Amir, Thanks for stopping by. Based on what you described, this tutorial will definitely provide you with the details.
You just need to create your explicit measures (Qty and Amount) and then create the calculation group for time intelligence calculation items.
Cheers!
Do you do some consulting?
Yes, I do. I assist small and medium- sized businesses. Check it out here: www.vizxlization.com/book-online
are you ecuadorian?
Thanks for stopping by. Please check out my website for more details about my ancestors and my company. quipuanalytics.com
@@NestorAdrianzen My last name is Nunez- Quispe. I also share similar ancestry with my family coming from Ecuador and Peru with Inca Origins