SQL, M or DAX?
We live in a world of choices and we have many tools at our disposal. In Microsoft Business Intelligence solutions using tools like Power BI and SQL Server Analysis Services, you have at least three different ways to perform data collection, transformations and calculations. A question I get all the time is: “Which database or BI tool should be used to perform routine tasks? Is it best to shape and transform data at the source, in Power Query using M script, or in the data model using DAX?”