Foundations of DAX

The lab includes DAX calculated measures and calculated columns utilizing filter context and row level context to support the development of strategic HR decision making solutions.

Welcome !

Topic : Explore Population Dataset & Identify Key Insights

1) Tables

2) Relationships

3) Star schema

4) Fact vs dimension tables  

Calculated measures are created using DAX functions such as aggregate functions, iterative functions, and CALCULATE functions, as well as functions that operate on single values rather than entire columns.  

1

Go to table view—> Table tools —--> Calculations —-> New measure  

2

Click on new measure and we can write any function supported for measure value just like formula bar in excel

3

Rename measure as per your objective by double click on and rename it Hit enter button

You can see new measure is available in your table with updated name   

4

We can apply any aggregate function( SUM, AVERAGE, MIN, MAX,COUNT)

Iterative function( SUMX, AVERAGEX, MINX, MAXX, COUNTX)

After '=' sign.

With syntax—>

Measure_name = DAXFunction(TableName[ColumnName])

We can apply any aggregate function( SUM, AVERAGE, MIN, MAX,COUNT)

1

Go to Table tools —> Calculations—> New Column  

2

Click on new measure and we can write any function supported for measure value just like formula bar in excel

3

Rename the new column and hit enter  

We can see , new column is available in the table

4

Write new column calculation either using DAX operator or using DAX function

ColumnName= DAXFunction(TableName[ColumnName]) 

Or

ColumnName= TableName([ColumnName]) DAXOperator TableName([ColumnName])

1

Go to Table tools→ Calculate —> New Table

2

Click on New table, Use any function which creates new tables : Filter Functions, Calendar Function, Calendarauto Function

3

Rename Table as New table name

Great job!

You have successfully completed the Foundation of DAX Lab with a strong understanding of Calculated Measures, Calculated Columns, and Calculated Tables.

Checkpoint

Next-Lab Preparation

Topic : Mastering DAX for Data Analysis

1) DAX Aggregated functions

2) DAX Iterative functions

3) DAX operators

4) DAX string functions, date functions