Chapter 10: Examples of M Usage
This chapter concentrates on a few examples of M usage, including the concatenate function. We will first compare the difference between formulas in Excel and Power BI, before looking at the ampersand operator (&
) and how it can be used. We will go through an example of how you can do this by using a simple name and surname concatenation formula.
We will examine how Text.From
and Text.Combine
can be used to join and concatenate different strings, dates, and columns. We will also learn how to set up our own SQL server legally and for free to use for non-commercial purposes; it will have full functionality. In doing this, we will also cover how to import the AdventureWorks
databases into SQL to use them as a resource.
Lastly, this chapter concentrates on parameters and how they can be used effectively to filter data sources, adding parameters to control statements that allow us to filter them according to different dates. We will continue by...