Webinar on How DAX Works | Evaluation Context | Filter Context & Row Context | DAX for Power Pivot and Power BI in Hindi

How DAX Works?

Why It's important to know how it is working on functions. because if you know how any language works then you can easily learn and write complex functions. DAX looks like Excel formula language but it has some unique and powerful context. It the Evaluation context, unlike Excel you have to define every test and input in the formula. But not in DAX.

There are two contexts that effect DAX calculation.

Evaluation Context  ( Fliter context & Row context)

Evaluation Context is a combination of the Filter & Raw context. it's mean there is a current context

which has some filters or slicers lavy on the current data model. In this webinar, we have discussed these concepts in detail.

 

Download Practice File From Here

DAX Versus Excel Formula Language Introduction to beginners

DAX Versus Excel Formula Language Introduction to beginners

You are familiar with Excel formulas. Now a day DAX becomes popular among IT professionals. because of its scope and power to solve with big data. unlike Excel, its formulas work on a column, not a single cell.

DAX is the programming language of Microsoft SQL Server Analysis Services (SSAS) and Microsoft Power Pivot for Excel later it comes with the bundle of Power BI.

Understanding the data model

DAX is a language specially created to calculate business formulas over a data model. You might already know what a data model is, but if you are not familiar with it, it is worth dedicating some webinars to a description of data models and relationships, so as to create a framework on which you will build your DAX learning.