Power BI DAX Essentials

✅ Iterators vs. Normal Functions

✅ Using SUMX()

✅ Using COUNTX()

✅ Using AVERAGEX()

✅ Using MINX()

✅ Using MAXX()

✅ Creating Variables

✅ Features of a Variable

✅ Location of Variable Evaluation

✅ Conditional Computations using Variables

✅ Increasing Code Readability

✅ Writing single and multi-line comments

✅  Modification of Filter context using CALCULATE()

✅ Modification of multiple Filter using CALCULATE()

✅ Mixing Filtering

✅ Using LOOKUPVALUE()

✅ Specifying the cross-filtering direction using CROSSFILTER()

✅ Activating Relationships with USERELATIONSHIP()

✅ Return all the rows in a table using All()

✅ Using ALLSELECTED()

✅ Modify how filters are applied using KEEPFILTERS()

✅ Using SELECTEDVALUE()

✅ Using CONCATENATEX()

✅ Implicit Calculate in Measures

✅ Row to Filter Context transition

✅ Using CALCULATE() and CALCULATETABLE()

✅ Using EARLIER() vs EARLIEST()

✅ What is Time Intelligence

✅ Date table properties for Time Intelligence

✅ Aggregations over time

✅ Total Year till Date, Month Till Date, and Quarter till Date

✅ Handling Fiscal Year

✅ Same Period Last Year

✅ Calculate the Running Total

✅ Using date modifier DATESBETWEEN

✅ Shifting forward/backward in time using DATEADD()

✅ Using DATESINPERIOD()

✅ Using MAX or LASTDATE()

✅ Using FIRSTNONBLANK() and LASTNONBLANK()

✅ Total Sales rolling 90 days

✅ Use of IF( ) statements

✅ Switching between cases using SWITCH( )

✅ Finding your text

✅ What to do if your text had one value

✅ Concatenating labels

✅ Using COALESCE( )

✅ What are hierarchies

✅ Parent-child hierarchies

✅ Using Path functions