Measures vs Calculated Columns - (1.5) Ultimate Beginners Guide to DAX 2020
HTML-код
- Опубликовано: 15 сен 2024
- DOWNLOAD RESOURCES HERE - enterprisedna....
START FROM THE BEGINNING - • Ultimate Beginners Gui...
Follow along to the beginners guide DAX tutorials by using the demo data available for download. Enjoy!
Details of what you will learn during this course
Learn - what DAX is and why you need to learn it when using Power BI
Learn - the basics of DAX calculations
Understand - formula syntax, writing comments & variables
Review - how the data model and DAX calculations work together
Learn - what the most important concept of DAX is - CONTEXT
Understand - what the CALCULATE statement does
Learn - what table functions are and when to use them
Review - time intelligence functions
Understand - how important learning DAX well is when using Power BI
Here are the specifics for the course
Learn how to;
Use DAX formula with Power BI
When and where to use DAX functions
Utilise some of the great features built into the DAX formula bar
Use the data model in combination with DAX formula
Understand the concept of CONTEXT
Use the CALCULATE statement
Create filters using table functions
Incorporate time intelligence functions in your analysis
Become a DAX master by combining patterns of DAX formula
**** Video Details ****
0:27 - Calculated Columns Explained
2:14 - Creating a Column
3:43 - Creating Calculated Column In LOOKUP Table
6:25 - Measures Explained
7:28 - Creating a Measure
10:45 - Summary
**** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterpri...
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterpri...
FREE - 60 Page DAX Reference Guide Download - enterprisedna....
FREE - Power BI Resources - enterprisedna.c...
Enterprise DNA Membership - enterprisedna....
Enterprise DNA Online - portal.enterpri...
Enterprise DNA Events - enterprisedna....
**** Related Links ****
Learn How To Harvest Power BI Slicer Selections To Use Within Other Measures
blog.enterpris...
Placing Workday And Weekend Day Numbers Into The Date Table In Power BI
blog.enterpris...
Show Results Up To Current Date Or A Specific Date In Power BI
blog.enterpris...
**** Related Course Modules****
Power BI Super Users Workshop
portal.enterpri...
Mastering DAX Calculations
portal.enterpri...
DAX Formula Deep Dives
portal.enterpri...
**** Related Support Forum Posts****
YTD as Calculated Column Instead of Measure
forum.enterpri...
What’s the Main Difference Between DAX in Columns vs Measures
forum.enterpri...
DateDiff to Only Calculate Number of Workdays
forum.enterpri...
For more Calculated Columns and Measures to review see here…..
forum.enterpri...
***** Learning Power BI? *****
FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterprisedna.co/p/ulti...
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterprisedna.co/p/ulti...
FREE - 60 Page DAX Reference Guide Download - enterprisedna.co/dax-formula-...
FREE - Power BI Resources - enterprisedna.co/power-bi-reso...
Enterprise DNA Membership - enterprisedna.co/membership
Enterprise DNA Online - portal.enterprisedna.co/
Enterprise DNA Events - enterprisedna.co/enterprise-d...
***** Related Links *****
Learn How To Harvest Power BI Slicer Selections To Use Within Other Measures
blog.enterprisedna.co/2018/12...
Placing Workday And Weekend Day Numbers Into The Date Table In Power BI
blog.enterprisedna.co/2019/07...
Show Results Up To Current Date Or A Specific Date In Power BI
blog.enterprisedna.co/2019/07...
***** Related Course Modules*****
Power BI Super Users Workshop
portal.enterprisedna.co/p/powe...
Mastering DAX Calculations
portal.enterprisedna.co/p/mast...
DAX Formula Deep Dives
portal.enterprisedna.co/p/dax-...
***** Related Support Forum Posts*****
YTD as Calculated Column Instead of Measure
forum.enterprisedna.co/t/ytd-...
What’s the Main Difference Between DAX in Columns vs Measures
forum.enterprisedna.co/t/what...
DateDiff to Only Calculate Number of Workdays
forum.enterprisedna.co/t/date...
For more Calculated Columns and Measures to review see here…..
forum.enterprisedna.co/search...
Been using PBI for 3 years and I never actually bothered looking into the difference between calculated columns and measures. Great explanation, and it makes sense. You would want to use a Calc Column if the calculation isn't required to happen on demand and in real time. You just create the column, and that's the end of it. Whereas measures are more optimal for doing *actual* calculations.
Hi Peter G, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials.
Here’s the link: ruclips.net/channel/UCy2rBgj4M1tzK-urTZ28zcA
great video Sam as always, can't wait to study your course
Hi dreamer, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!
One of the best videos out there if you want to master DAX in Power BI. Awesome content and work!
Well explained. Thanks!
Hi @Alma-im4qk, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming data skills and AI tutorials, and announcements. Cheers!
Thanks a lot for the video. One of the best explanations on when to use calculated columns vs measures.
Glad you liked it. Please don't forget to like and subscribe :)
That was really helpful for me to clear some ambiguities in my mind.
Hi Masha, great that you found value in this video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Cheers!
Very good lecture. Thanks!
Great Info!!!!
thanks , very informative videos
@EnterpriseDNA the link to the downloads is no longer working, could you please look at it again, so we can follow along. Thanks
Great explanation. Thank you. Quick question. You used a measure to display total qty per customer. The column used in the measure could have been dragged in instead and isn't a calculated column (it already existed in the model). Was this just for demo purposes or do the performance benefits you described apply here also?
Hello Owen Vachell,
Thank You for question. We appreciate your time.
Firstly, it's always a recommended best practice to create a measure and use them in the analysis rather than dragging the naked column/field from data model. Those columns can only be helpful in the initial level of analysis but what-if one needs to construct the complex analysis then in that case, those base measures which are created in the data model will help in creating the secondary level of measures.
As far as performance benefits is concerned, one needs to understand first how the model is reacting and learn the basic fundamentals of Power BI before diving deep further into the performance analysis. In order to learn more about the Optimization of Data Model and DAX, we've created a course which specifically focuses onto these core areas. Below are the links of the course provided for the reference:
portal.enterprisedna.co/courses/enrolled/1647530
portal.enterprisedna.co/courses/enrolled/1654804
portal.enterprisedna.co/courses/enrolled/958368
For more queries, you can also reach out to us through our Community Forum where our members as well as Experts Team will be able to assist you, in a better and efficient manner.
I hope this helps.🙂
Please make sure that you're subscribed to our RUclips channel so you don't miss out any updates regarding Power BI. Along with it, you may also be interested to join our Power BI group on LinkedIn to receive latest updates. Links provided below for your reference.
Happy Learning!!!
Thanks and Warm Regards,
Enterprise DNA
forum.enterprisedna.co/
ruclips.net/channel/UCy2rBgj4M1tzK-urTZ28zcA
www.linkedin.com/groups/12004506/
Great video.
Hi Icinine, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials.
Here’s the link: ruclips.net/channel/UCy2rBgj4M1tzK-urTZ28zcA
Sir. Why you have put in Sum X function (sales table first & related table in 2nd argument)
Can't we change the order as we are multiplying product * price or price * product will give the same results
Hello DIVYA MEHTA,
thank you for posting your query onto our channel.
Well, if you observe the "SUMX()" function it's like - SUMX( Table, Expression) so in the given video we've referenced the Sales table as a first argument and then the columns from the respective tables are referenced as a second argument. If you try to do something like this -
Total Sales =
SUMX(
Sales, RELATED( Products[Current Price] ) * Sales[Quantity] )
Still you'll get the same results because table is referenced only once and columns are only interchanged will referencing it. So yes, you can change the order but it's a best practice to maintain the order while writing the formula.
For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well.
Hoping you find this useful and meets your requirements that you've been looking for.
Happy Learning!!!
forum.enterprisedna.co/
Why do you need to create a measure to calculate the quantity when you can just drag and drop the quantity field from the sales table? does it make things quicker?
Hello Tuvshinjargal Narankhuu,
Thank You for posting your query onto our channel.
When you drag the "Quantity" field/column from the data table directly they're known as "Implicit Measures" and they can only perform basic functions such as SUM, MIN, MAX, AVERAGE, etc but they cannot help you perform some advanced analysis for that you'll be required to write the measures.
Below are some of the reasons mentioned why one should write measures rather than referring implicit measures -
You cannot control what an implicit measure does beyond the basics. Sum, Count, etc.
You cannot reuse an implicit measure. Say you want to have a Sales measure, a COGS measure, and a Margin measure. If you write explicit measures as follows:
Sales = SUM( Table[Sales] )
COGS = SUM( Table[COGS] )
Margin = [Sales] - [COGS]
Now you are reusing explicit measures in step #3. If you had not created those, you would have to write this:
Margin = SUM( Table[Sales] ) - SUM( Table[COGS] )
Believe it or not, #3 and #5 are not the same thing. #3 wraps in implicit calculate around each measure, #5 does not, so to be accurate, #5 has to be #7 to produce intended results.
Margin = CALCULATE(SUM(Table[Sales])) - CALCULATE(SUM(Table[COGS]))
If you go to the trouble to add conditional formatting or other field settings, like a custom number format with an implicit measure then you decide you want to tweak the formula for that measure, you cannot. You have to now create an explicit measure with your correct formula
To help you understand it better. You can go through the link given below -
ruclips.net/video/nJSXty9Y4tM/видео.html
And can also check out the course of "Ultimate Beginners Guide to Power BI & DAX" which is free to all the members.
Thanks and Warm Regards,
Enterprise DNA
pls share the ms file to practice
Hi shailesh, thanks for posting your comment in the video. All pbix file/datasets/resource files are available for download in the Enterprise DNA Online, which is accessible via Membership. Check out the link below. Thanks!
portal.enterprisedna.co/
The model effectively replicates a vlookup?
Where do you download the demo dataset?
Hi, demo datasets are available inside Enterprise DNA Online which is accessible via membership. If you are interested in this, you may follow the link here: enterprisedna.co/membership
Good lectures and thank you for the material..
Hi Varun, gald it was of value to you. Please don't forget to subscribe to our channel and share this video to those who might need it. :)
@@EnterpriseDNA Subscribed ever since started working with BI