Microsoft Power BI DAX from Scratch
In this course, you will
1. Understand the concept of DAX and how to create calculate column, measure, tables, and quick measures
2. From the exhaustive list of DAX functions, we will be looking into the most frequently used functions from the family of
- Date and Time function – WEEKDAY, EDATE, EOMONTH, DATEDIFF, TODAY, NOW
- Text function – FORMAT, COMBINEVALUES, LEFT, RIGHT, FIND, UPPER, LOWER, UNICHAR, REPT
- Logical function – IF, Nested IF, AND, OR, SWITCH
- Relationship function – RELATED, CROSSFILTER, RELATEDTABLE
- X-function – SUMX, RANKX
- Filter function – CALCULATE, ALL, EARLIER, FILTER, LOOKUPVALUE
- Statistical function – DISTINCTCOUNT
- Time intelligence function- DATESYTD, DATEADD, SAMEPERIODLASTYEAR
- Information function- CONTAINS
- Table manipulation function- SUMMARIZECOLUMNS
