DAX for Power BI Part 2.1 - Basic Calculated Columns in DAX

By Andrew Gould

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:

This video explains how to create calculated columns in DAX. You'll learn about the important concept of Row Context and a variety of ways to reference a column in a DAX expression. You'll see how to add comments and lay out your code for readability. You'll learn about the order of operation and how to control it and how to use some basic DAX functions. You'll also see how DAX adjusts the data type of a column as you make changes to the expression. Finally, you'll learn how to concatenate multiple values to create a longer value.

Chapters
00:00 Topic list
00:47 Importing the Sample Data
02:17 Calculated Columns and Row Context
03:53 Creating a Simple Calculated Column
08:04 Alternative Ways to Reference Columns
11:25 Comments and Multiple Lines
15:01 Using Calculated Columns in Report Visuals
16:42 Controlling the Order of Operation
19:33 Referring to Existing Calculated Columns
20:28 Using a Function to Divide Values
24:11 Implicit Data Type Conversion
26:53 Converting a Decimal to a Whole Number
30:15 Concatenating Text
31:37 Calculating the Remainder of a Division

[briandennehy]

It's ridiculous really that Wise Owl offer this content for free. Best tutorials on you tube for SQL, VBA, Python and Power BI. Thanks so much 👍

[mangethezwane]

I think your voice should be used in all tutorials on YT😅. Thank you for all the great content.

[hemalkarambelkar]

Lov the way how you even cover minor details like squre brackets and single quotes and explain the things in step by step manner.

[brendas]

These are EXCELLENT training videos. Top notch. Thank you!

[AZ_German]

You are now my go-to Dax guru. Thanks!

[tejamarneni]

Hi Andrew. Thank you so much for the video on Power BI. My job includes a lot of working with power bi these days. Your videos are really helpful.

[wayneedmondson]

Hi Andrew. Thanks for another awesome Basic DAX / Power BI lesson! Even though some of this is review, I still learn new things from your thorough explanations. Looking forward to more :)) Thumbs up!!

[fabriciocarranza]

Hello teacher, learning new things from you again. Thanks for sharing your amazing knowledge with us.

[elicesroman]

I've just came across these series of videos. What an amazing introduction ! I believe you touched all the key concepts in Power BI. Looking forward to watching the series. Thanks for the videos.

[KumarAnalytic]

*That's really great pleasing for me to see you in video. I was really wishing you to see you amazing people really with an amazing explanation skills. You all are really brilliant person, I've never seen any people better than you in terms of teaching and explanation. My great gratitude towards you, hats off*

[markbocsor]

Hi Andrew, crystal clear explanations, thank you

[kartickchakraborty]

Happy New Year to my Dearest Respected Sir.

[hadibq]

👍Thank you!! lot's to learn know here! :)

[PankajNegi]

Great Sir, and Very informative session Power BI - DAX. Sir If this possible to make some videos where compare Excel and DAX function side by side.

[The_Code_Father]

Will the members only videos remain unavailable for non members permanently or will they be available after a certain period ?

[aryan-letslearntogether]

Please can you do a video on linked files and how tp auto update links in files in multiple locations

[ahmedaiad]

I watched many videos for you in power bi and vba, and that made me wonder if you are working as freelancer with those skills or not

[yashchawla]

A video on vba properties? How to use them like get set properties as functions and all?

[tonnyakoi]

Can someone point me to the excel data file?