DAX Fridays! #46: What is the difference between calculated column and measure in Power BI?
ฝัง
- เผยแพร่เมื่อ 5 ต.ค. 2024
- In today's video, we will learn the difference between a calculated column and a calculated measure. Enjoy!
EXCEL SURVEY: 1drv.ms/xs/s!A...
PREVIOUS VIDEO: • DAX Fridays! #45: Cale...
NEXT VIDEO: • DAX Fridays! #47: NETW...
Looking for a download file? Go to our Download Center: curbal.com/don...
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
Join our DAX Fridays! Series: goo.gl/FtUWUX
Power BI dashboards for beginners: goo.gl/9YzyDP
Power BI Tips & Tricks: goo.gl/H6kUbP
Power Bi and Google Analytics: goo.gl/ZNsY8l
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/...
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Twitter: @curbalen, @ruthpozuelo
► Google +: goo.gl/rvIBDP
► Facebook: goo.gl/bME2sB
#daxfridays #curbal #SUBSCRIBE
► Linkedin: goo.gl/3VW6Ky
One important thing you overlooked here, Ruth! 'Calculated Columns' is a must if one wants to show the values in a slicer or in other words if one wants to filter. The 'Calculated Column' example that you have shown in the video can also be alternatively done inside a measure with the help of an iterator function (SUMX) and that will also calculate row-by-row. But if I want to create some range groups based on that column value and later use that in a filter/slicer, then that cannot be done. In that case I have to create a Calculated Column only.
Finally I understood Ruth ! Gracias ;-) que te vaya bien y que tengas un buen fin de semana !!! 🙋🏼♂️
+SmartBimson Igualmente! Estoy en Asturias con la familia, no puede ser mejor :)
/Ruth
Curbal es Asturias 👍🏻 wie bonito allá ! Yo era de viaje en chino, hay unos lugares tan bonita allá .. y por eso estoy tarde con mi dax friday :-( a los chinos no les gusta yt
+SmartBimson 😂
De vacaciones o trabajo?
/Ruth
Curbal trabajo , pero de vacaciones también me gustaría !
Simple and easy to understand. Thanks Ruth!!
Great and thanks for the feedback!
/Ruth
Superb video for calculated column vs calculated measure
Excellent! Glad it was useful :)
/Ruth
Hi Ruth, great video.
do you have any video showing how to make a slicer to filter a calculated column ?
Thanks for the differentiation!!! : )
+ExcelIsFun You welcome and happy Friday!
No vacation yet?
/Ruth
Vacation and days off are only to really get down to working hard : ) Just time to work and be more efficient!
+ExcelIsFun For me vacation is family, friends, good food and tons of do nothing hours ... Spanish blood, what to say... ! ;)
That is awesome : ) Spanish blood is great : ) I have some great Spanish friends and now I have one more in you! Always for me, I just have too many new entrepreneurial ideas, (as a business owner in the 1980s and 1990s and now as an educator), so when i have free time, it is time for me to create and innovate. I guess that means, since i love my work, I get to work most of the time.
+ExcelIsFun Hi Mike, that sound fantastic! What kind of innovation are you into? Mechanical, hardware?
Jezzz, we should live closer so we could talk with a beer in hand ;)
Looking forward Isaak Asimov time travelling methods...
/Ruth
Great Information!! Thank You Very Much.
+rajan77 Awesome! This was one of the things I wondered when I started with PowerPivot. Hopefully it helps other get started faster! :)
/Ruth
Is there any scenario or comprehensive rule, where we definitely have to use calculated column essentially (i.e. where measures cannot be used) and vice versa OR All the DAX functions can be applied via calculated column or measures with equal effectiveness (barring only the race between CPU and memory usage) ?
+Bilal Zia Hi Bilal,
If you want to use the column for a relationship between tables you need To use a calculated column and sometimes you might need to use a supporting calculated column for simplicity or due to complexity.
I would say the rule of the thumb is to try to create a measure and if not possible create a calculated column :)
/Ruth
Thanks Ruth. I am worried about efficiency of data model now a days. I am planning a website using Power BI embedded and a little worried how would my model respond with the presence of concurrent users . and whether having too many measures could effect the performance in such case. Also Is there any software that can be used to time how much time is take to run a specific measure ?
+Bilal Zia Hi Bilal,
Yes there is! You can do that with DAX studio,
Test it out :)
/Ruth
Hi Curbal , it would be great, if you can throw some light on how to use Microsoft Azure service for storage of data and how to get data into power BI from same .
Really like your videos , very simple easy to learn new DAX Formula each week.
Actually I have implemented power BI dashboard for our whole organisation ,that to in a middle eastern firm , which now has moved light years ahead in analytics after that atleast on monthly financial KPIS
+inder garg Congrats on your dashboard, well done!
Absolutely, I can do a video about that :)
/Ruth
Hi Ruth, I am not getting across the row for measure can you please explain me in the Excel please Ruth
Awesome 👌explained perfectly
Fantastic and Thanks for the feedback:)
/Ruth
Hi Ruth,
Is it possible to show forecast sales based on the present sales using DAX.
Thanks
Vamsi
+Vamsi Babu I always say everything is possible!
Post your scenario in the power bi community to get a more precise answer ;)
I will do a video on this in the future, great tip!
/Ruth
Got confused , even ini the case of measures the formula remains the same it will not get changed like calculated columns ,, isn't it ? In the report canvas even for the calculated columns based on the filter for ex for a date filter the calculations will change
Nice Video.. Great Examples and Material PPT and all ..Thanks
My pleasure :)
Great video Ruth!. I had a question though, would adding a custom column in 'Transform data' consume memory too??
Thank you a lot
whuch one is give better performance calculated column or measure?
why?
Ashok measures
Hi Ruth,
What if I have a column which is already calculated in the table which is pulled in power bi, how this will be handled
Hi,
Can you please ask in the power bi community? Thanks!
/Ruth
Really helpful ....
+Ankush Joshi Thanks Ankush and happy Friday!
/Ruth
Hi Ruth good video again ,
+Mark Dawson Thanks Mark and happy Saturday :)
/Ruth
Hi Ruth, Nice Video Many Thanks!!!
Question for you .. i have couple of PBI reports embedded ( Published to share point ) is there any ways to export those PBI reports to Excel from the share point site ? Thanks
+yet nat Hi! Thanks!
The only ways I know are these:
powerbi.microsoft.com/en-us/documentation/powerbi-service-export-data/
Not aware you can do that ... anybody here knows?
/Ruth
Great.... we next need row and context transition :D
+RRR program :) True , it is now in my to do list!
Happy Friday ;) /Ruth
Hope, I get to see some advanced examples in row and context transition video..
+RRR program I will start with simple samples and build from there. Most of my audience are beginners. For hardcore context explanations you must travel to Italy ;)
/Ruth
Watching it anyhow :)
+Emin Uzun 😂 thanks! Let me know if I forgot something!
/Ruth
Buenos dias Ruth, gracias nuevamente por tu aporte pero veo un detalle y no se si me equivoco. Cuando explicas en PowerBI lo de la Columna Calculada, en el minuto 4:35, el campO AvgUnitPrice es una medida, no una Columna Calculada. Luego cuando explicas la Medida en el minuto 6:41 usas una Columna Calculada. Es una equivocación o es asi el ejemplo? Porque tengo un caso y necesito entender mas esto porque lo que creia de estos 2, ya no lo es.
Gracias
+Julio Bolivar Hola Julio, ahora mismo no puedo ver el vídeo, probablemente lo haya dicho mal. Una vez que este de vuelta de las vacaciones lo miro.
/Ruth
Hola Julio, no entendiste el video tienes que verlo todo para comprender lo que ella explica. Super claro lo que dice.
Measures part is not clear
Column part is clear as a sunny day .. Measure part is as clear a Mud.
Needs to be more to the point on measure as it was done with column.
Can you use a calculated Column in a DAX measure?
Yes
when i am trying to multiply two column by using measure & Calculated column, it will give me two diffrent result. can you please tell what am i doing wrong in this
That is better suited for the power bi community (community.powerbi.com) , can you please post your question there? Give as many details as possible to get help.
/Ruth
That is better suited for the power bi community (community.powerbi.com) , can you please post your question there? Give as many details as possible to get help.
/Ruth
That is better suited for the power bi community (community.powerbi.com) , can you please post your question there? Give as many details as possible to get help.
/Ruth
Hi Ruth mucho tiempo sin saber de tí, ni estarla molestando con mis ocurrencias quería pedirte un favor y hacerte una pregunta simple, es posible crear una columna calculada que contenga el valor de una medida, por ejemplo tengo una medida que calcula la cantidad de días entre dos fechas (Ejemplo 28 días), y quiero utilizar ese valor para calcular el promedio diario en una columna calculada, eso es posible o estoy planteando mal el problema?, ahí disculpa que te pregunte a tí pero no se a quien más preguntarle. Gracias.
Ya el video me contesto la pregunta, y no se como hacer q una columna me agarre un valor estático de una medida.
Hola Alexis,
Los valores de una columna son siempre dinamicos y Se pueden incluir en columnas.
Para recibir ayuda detallada, escribe en la comunidad de power bi, y da todos los detalles posibles.
Saludos!
/Ruth
urgent could you pls help me