LEARN DAX IN POWERBI DESKTOP - Part 1/2

LEARN DAX IN POWERBI DESKTOP - Part 1/2 free download

DAX learning in BI - From Basic to Advance - Part1/2

• What is DAX Measure and Calculated Column (This is Part1 series  of DAX)

• What is the difference between Measure and Calculated Columns in terms of functioning and fundamentals.

• Which one is better or which one to choose while writing DAX Formula in PowerBI

• To begin with , Learn first how to write DAX in PowerBI window. How to write SUM,AVERAGE,COUNT,MAX,MIN,DIVIDE . Its different from excel in terms of fundamental.

• Learn amazing DAX functions like SUMX, COUNTX,FILTER

• How to use One DAX into another DAX ,If situation demands.

• What is a DAX Studio and how it can help you in understanding DAX

• Most versatile and used DAX in POWERBI - CALCULATE - From basic to advance

• Utmost important DAX like - ALL , ALL SELECTED, ALL EXCEPT

• Mixing of ALL with CALCUALTE to yield powerful results

• How to write IF dax as a calculated column

• How to write IF as a measure. Its fundamentals which is important.

• Use of DISTINCT and DISTINCTCOUNT and what is the difference between them.

• How to handle multiple conditions in a simpler manner using SWITCH Dax. Its alternate to your IF Dax.

• What is IN and NOT dax. Check out their use.

• Get ready for surprise Tests.

• Ask anything on the forum related to DAX. You will have my support .

• TEXT Functions like LEFT, RIGHT, MID , FIND, SUBSTITUE - Learn their importance in Data crunching.

• How to find out top or bottom scores in a table. For eg, how to find top scorers or sales revenue values . Learn TOPN in full detail.