Measures vs Calculated Columns - (1.4) Ultimate Beginners Guide to DAX 2019

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? *****

***** Related Links *****
Learn How To Harvest Power BI Slicer Selections To Use Within Other Measures
Placing Workday And Weekend Day Numbers Into The Date Table In Power BI
Show Results Up To Current Date Or A Specific Date In Power BI

***** Related Course Modules*****
Power BI Super Users Workshop
Mastering DAX Calculations
DAX Formula Deep Dives

***** Related Support Forum Posts*****
YTD as Calculated Column Instead of Measure
What’s the Main Difference Between DAX in Columns vs Measures
DateDiff to Only Calculate Number of Workdays
For more Calculated Columns and Measures to review see here…..

[EnterpriseDNA]

Related Links
Learn How To Harvest Power BI Slicer Selections To Use Within Other Measures
Placing Workday And Weekend Day Numbers Into The Date Table In Power BI
Show Results Up To Current Date Or A Specific Date In Power BI

Related Course
Power BI Super Users Workshop
Mastering DAX Calculations
DAX Formula Deep Dives

Related Support Forum
YTD as Calculated Column Instead of Measure
What’s the Main Difference Between DAX in Columns vs Measures
DateDiff to Only Calculate Number of Workdays
For more Calculated Columns and Measures to review see here…..

[shooch]

Nice explanation, still trying to figure out why i can do a measure/quick measure but the option for column is greyed out.

[jonlong]

I’m really new to BI so thanks for the content. I’ve played around a bit with power query as well and have a very limited knowledge of M.
My question is why you do

[jonlong]

I’m really new to BI so thanks for the content. I’ve played around a bit with power query as well and have a very limited knowledge of M.
My question is why you do some things in DAX when you could also do it in power query. For example you shortened the month name to 3 characters using a DAX calculation. Is it inefficient to do the same thing in power query?

[eddiezee]

Sorry, I cant seem to download the Data Files. Clicking on the link takes the user to a pop up window that displays a message 50% complete. Asking the user to provide Name and email address. After clicking the Submit button the pop up continues to display Submitting with the 50% Complete message and remains perpetually the same. I have logged in to my email account multiple times but I have not received any files.
It would be much simpler to download the files from the youtube.com page itself rather than Navigating the user to an external web site where they are required to provide there Name and email address.
I am frustrated and disappointed as the material looks very enticing but without the Data files a user can simply admire the visuals but is unable to learn much.

[Gledii]

Hi, i have a measure that calculates the SUMX of seveal columns. Now i just want to create a new measure to calculate the % of the previous one. somehow i cant load the previous measure, it only let me use the Sum function with columns...any tip? thanks

[ramandeepsingh]

I am using this fle from the the link sent- Ultimate Beginners Guide to DAX data file, and this doesnt seem to have DATE sheet unlike you model which has the date table. Have you created it in power bi itself .

[erniecortes]

The best explanation I've watched 👍

[jakeo]

I've see many of this guy's videos. Best teacher ever. Thank you.

[franciscocarmonafarfan]

Gracias por hacer las diferencias y saber cuál usar.

[azramathias]

This is an excellent resource, thank you.

[PakFan]

Hi When would you use SUM as apposed to SUMX

[michaelgearhardt]

hey @Enterprise DNA.. was wondering if you could create a column in a matrix that runs a calculated measure based off 2 other columns within the matrix. Does that make sense?


Thanks for the great video!

[soymb]

Hi Sam, if you have more than 1 mill of record, what do you recommend, calculated columns or measures? What option is faster and less consuming of memory and resourses of the computer?

[abdulassees]

Really Cool Explanation. Thanks a lot!!!

[rrrprogram]

Hi Sam, I have a question on context transition....

As in ur data model... Customer and Product dimension tables are connected to Sales table...

If I write a formula in the CALCULATE COLUMN of product table as below

Product [SalesWithSUMX] =
SUMX ( Customers, CALCULATE ( SUM ( Sales[SalesAmount] ) ) )

Does the SUMX iterates over all the customers in the table ????

[pratikfutane]

Hi Sam,
Have a question on Measure Vs Calculated Column.
I have to sum the columns from two tables. for which i wrote a DAX as SUMX = SUMX(Table1, Table1[Value1])+SUMX(Table2, Table2[Value2])
where value1 and value2 are columns i need to sum.
when i use the above DAX in measure, it gives me correct result but
when i use the same DAX with Calculated column, it gives me wrong result. Could you please throw some light here....Sincerely Pratik

[brandondensmore]

Great video - thank you for sharing your insights!

[J_u_r_i]

wow such a nice explanation...thank you very much

[ahmedkhedr]

I have a problem with downloading resources< Kindly check the link attached to video