Summary
In this final chapter of the book, you have learned all about the differences between DAX and M functionality. You will now be confident in identifying the different parts of the DAX formula syntax structure and should be knowledgeable about where to construct DAX formula in Excel, Power Query, and Power BI.
We also touched on IntelliSense, which aids in DAX formula construction, and we know about the three main types of DAX formula (which are calculated columns, calculated measures, and calculated tables). You can create a calculated column, as well as quick measures and calculated measures. You can also create folders in which to store measures in the Field list of the Power BI interface. Measures will help you construct an expression formula to calculate a result specific to a purpose, dynamically and in real-time.
We hope that you now have a wealth of knowledge after reading this book and that it has instilled a desire to learn more about this extremely powerful...