Learn how to create Calculated Columns and Measures in DAX. You will learn differences between Row Context and Filter Context. and you will learn in which conditions you have to use Measures and where you have to use calculated columns. You will learn some DAX basics in this video as well. You will learn functions such as Related and RelatedTable in this lesson as relationship functions in DAX.
DAX, or Data Analysis eXpression is the language for querying and creating calculated measure and columns and tables in Power BI, SSAS Tabular, and Power Pivot. So one of the critical learning path for Power BI is learning DAX. In this lesson you learn basics of DAX and also some examples of using time intelligence functions in real world.
Time Intelligence functions in DAX are helpful in time analysis and creating calculations for year to date, quarter to date for calendar or fiscal categories. In this lesson you will learn how to use functions such as TotalYTD and TotalQTD combined with a date dimension to create measures in DAX and Power BI. You will also learn the difference between Power Pivot which allows you to set a date table, and Power BI which you have to add the ALL(
In addition to existing DAX functions for time such as TotalYTD and QTD, there are some expression that needs another function. In this lesson you will learn about CALCULATE function. You will learn how this function can be used with combination of a filter and expression to achieve a time intelligence measure. You will learn this through examples of creating running total and same period last year measures.
In this lesson you will learn how to write more complex DAX expressions through an example of calculating average rolling 12 months sales. for this example we will be using Calculate and some other functions to calculate sum or rolling 12 month, and number of months, and then dividing them. You will learn functions such as; CountRows, Divide, LastDate, NextDay, DatesBetween, and Calculate in this lesson.
This quick lesson covers best practices and tips that you have to follow when designing a data model in Power BI. Tips includes naming standards, data types considerations, formatting and categories. relationship, filtering data rows before using it, creating star schema model, and some other tips that helps performance and readability of the data model for end user.
Calculated tables first introduced in September 2015 update of Power BI Desktop. The name speak for itself; these are tables created by calculation. As these are in-memory tables their calculation is based on DAX (Data Analysis eXpression language). There are many benefits of using Calculated tables, such as using them for role playing dimensions (for example having more than one date dimension in a model), There are some DAX functions and expressions that returns a table as a result, and using them as table in your model sometimes is really helpful. for example you might want to create a table for top 10 customers and then use that as the main source table in many reports. In this lesson I’ll explain to you some use cases of calculated tables.
Power BI is a cloud service, and that means Power BI files are hosted somewhere. Some DAX functions such as Date/Time functions work on system date/time on the server their file is hosted on. So If you use DAX functions such as TODAY() or NOW() you will not get your local date/time, You will fetch server’s date/time. In this lesson I’ll explain methods of solving this issue, so you could use Power BI to resolve your specific time zone’s date and time.