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 PowerBITo 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, FILTERHow to use One DAX into another DAX, If situation demands. What is a DAX Studio and how it can help you in understanding DAXMost versatile and used DAX in POWERBI - CALCULATE - From basic to advanceUtmost important DAX like - ALL, ALL SELECTED, ALL EXCEPTMixing of ALL with CALCUALTE to yield powerful resultsHow to write IF dax as a calculated columnHow 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.
