In this (DAX 101) Video series, I’ve created DAX (Data Analysis eXpression) Columns and Measures. In this final video in DAX 101, I’ll put some of the work together to create some new visuals.
Month: June 2019
Using DAX Measures across multiple Queries in Microsoft Power BI
In this Video, I’ll create a DAX (Data Analysis eXpression) Measure. This measure creates the Salesperson Commission amount. To achieve this, I’ll have to multiply two fields together that reside in different queries.
Using DAX Measures that Counts the number of Invoices in Microsoft Power BI
In this Video, I’ll create a DAX (Data Analysis eXpression) Measure. This measure will be used to count the number of Invoices. The same measure will show the number of invoices for each Customer and the numbers of invoices for which each item appears.
Making Tooltips easier to read in Microsoft Power BI
In this video, I’ll show you how to format Tooltips in a Microsoft Power BI visual to make them easier on the eyes. The default of white letters on a black background can be difficult to read. This 2-minute video will show you simple changes that make tooltips more powerful!
Using DAX Measures that calculate by row rather than a summary, in Microsoft Power BI
In this Video, I’ll create a DAX (Data Analysis eXpression) Measure. This measure will be used to calculate the total sales price. Check out this video to see how to create a measure that performs “Aggregation with Iteration”; which is a fancy way of saying DAX needs to calculate the total sales price for each row, then sum it together. Look at the two examples below and you’ll see why.