Learning about the DAX and M functionality
In this section, you will learn the differences between DAX and M and find out when each one is used, as well as their functions.
DAX is mainly used in data transformations in Power BI dashboards where you would need to gain business analysis from existing data models. DAX is powerful when required to produce, for instance, growth percentage analysis across a list of products for specific date ranges, or to analyze market trends. Together with Power BI, DAX can powerfully assist with real-world business challenges to create meaningful, interactive business dashboards for reporting and decision-making. It is a formula language; it is not considered a programming language as it is structured using custom calculations (in fields and columns). As a formula language, DAX comprises an assembly of the following:
- Operators
- Constants
- Functions
Now, M code is used in the Power Query editor. Each time you create a transformation...