-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating

Power Query Cookbook
By :

Generally, when you are presented with Power BI as a business intelligence tool and start exploring Power Query in it, you will use two code languages that have similar functionalities – DAX and M code – and you will probably get confused by these similarities. In this recipe, we will discuss the main differences between these two languages and when it is better to use one instead of the other. To illustrate the main differences between them, we will create an additional column with both M code and DAX.
In this recipe, you need to download the FactInternetSales.csv
file.
In this example, we will refer to the C:\Data
folder.
Once you open your Power BI Desktop application, you are ready to perform the following steps:
FactInternetSales.csv
file and open it. The following...