Hands-on guide to Microsoft Power BI DAX
Instructed by Learnsector LLP 3 hours on-demand video & 9 downloadable resources
What you’ll learn
-
A beginner to intermediate guide on how to create DAX formula
-
Understand the concept of calculated column, measures, and tables in DAX
-
How to solve the problem statement using various DAX function
- Understand the concept of DAX and how to create calculate column, measure, tables, and quick measures
- 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
Requirements
-
Power BI desktop installed
-
A basic understanding of Power BI desktop
-
Know how to create data models
Who this course is for:
- Anyone dealing with report creation and providing data insights.
Similar Course Coupons
Deal Score0
Disclosure: This post may contain affiliate links and we may get small commission if you make a purchase. Read more about Affiliate disclosure here.