Dashboards and Tool in Excel & Power BI
We help your data to tell you the right story
Category: M-Code
-
Can I buy you a drink? Here is a magic cocktail: M-Code mixed with VBA
Combining VBA (Visual Basic for Applications) with M-code (Power Query M Language) indeed creates a powerful combination for automating data transformations, querying external data sources, and enhancing data processing capabilities in Excel. Here’s how you can leverage this “magic cocktail” of VBA and M-code: Benefits of VBA + M-Code Integration Example: Integrating VBA with M-Code…
-
Understanding DAX and M-Code: Tools for Data Modeling and Transformation
In the world of data analysis and business intelligence, DAX (Data Analysis Expressions) and M-Code are two powerful languages used primarily in Microsoft Power BI, Excel, and other related tools. Both languages have specific purposes and are crucial for data transformation and analysis. Here’s an overview of each, along with their differences and typical use…
EMZ: Data visualization, Data Artis 