Setting up parameters
You have the possibility to manage in a flexible way which data to load in the model. You can define parameters and use them in inputs for multiple transformations such as filtering or enriching data. In this recipe, we will see how to define parameters and how to use them when adding a conditional column based on some threshold values where you want to add a flag for each value of an existing column.
Getting ready
For 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:
Figure 6.1 – Text/CSV connector
- Browse to your local folder where you downloaded the
FactInternetSalesCSV file and open it. The following window with a preview of the data will pop up. Click on Transform Data:
Figure 6.2 –...
