Posts

Showing posts from September, 2018

Introduction to DAX (Quick Overview)

Image
This is just an overview of DAX language . We will begin calculations and extensive analysis on my next post.Enjoy. What is DAX?: Data Analysis Expression(DAX) is a Functional Language currently used in Power BI Desktop ,Analysis Services Tabular and Power Pivot for Excel. It is a collection of functions that can be used to calculate and return one or more values. In DAX, functions can contain other, nested functions and value references depending on your model and key business questions to be answered. DAX includes some of the functions used in Excel formulas plus other functions designed specifically to work with relational data and perform dynamic aggregations. Why DAX?: The difficult questions raised facing a business or an organization can be simplified using DAX, to shed more light into your data. Learning how to create effective DA