DAX Calculated Columns

Leave a comment

Let’s start with a dataset that has sales orders. There are sales order lines:

And the data looks like this:

However, there is no extended price in this dataset. To calculate it, let’s add a new calculated column. Click on the ellipse on the dataset:

And select New column:

Add the formula:

The new column will appear in the dataset:

And the new column can be added to our Power BI table:

You can then use that calculated column in measures:

And other calculated column calculations:

 

THANKS FOR READING. BEFORE YOU LEAVE, I NEED YOUR HELP.
 

I AM SPENDING MORE TIME THESE DAYS CREATING YOUTUBE VIDEOS TO HELP PEOPLE LEARN THE MICROSOFT POWER PLATFORM.

IF YOU WOULD LIKE TO SEE HOW I BUILD APPS, OR FIND SOMETHING USEFUL READING MY BLOG, I WOULD REALLY APPRECIATE YOU SUBSCRIBING TO MY YOUTUBE CHANNEL.

THANK YOU, AND LET'S KEEP LEARNING TOGETHER.

CARL

https://www.youtube.com/carldesouza

 

ABOUT CARL DE SOUZA

Carl de Souza is a developer and architect focusing on Microsoft Dynamics 365, Power BI, Azure, and AI.

carldesouza.comLinkedIn Twitter | YouTube

 

Leave a Reply

Your email address will not be published. Required fields are marked *