Using M and DAX – differences
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.
Getting ready
In this recipe, you need to download the FactInternetSales.csv
file.
In this example, we will refer to the C:\Data
folder.
How to do it…
Once you open your Power BI Desktop application, you are ready to perform the following steps:
- Click on Get Data and select the Text/CSV connector.
- Browse to your local folder where you downloaded the
FactInternetSales.csv
file and open it. The following...