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
This course includes:
- 3 hours on-demand video
- 9 downloadable resources
- Access on mobile and TV
- Full lifetime access
- Certificate of completion
Description
If you are someone dealing with reporting, with the help of DAX functions you can unlock the advanced power of reporting in Power BI. These functions will help you get better data insights.
DAX or Data Analysis Expression is a library of functions and operators, using which you can create formulas and expressions. This will help you with creating powerful formulas to ease your data analysis and reporting process.
This course is designed in a Problem Statement – Solution format where we start with the problem to which a solution is sought with the help of DAX functions where each component of the expression is clearly explained in easy-to-understand terms,
What is in store for you?
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
How to Get this course FREE?
Get a 100% Discount On Udemy Paid Courses by clicking on the Apply Here Button. This Course coupon code is automatically added to the Apply Here Button.
Note: The udemy Courses Will be free for a Maximum of 1000 Learners can use the promo code AND Get this course 100% Free. After that, you will get this course at a discounted price. (Still, It’s a good deal for you to get this course at a discounted price).
External links may contain affiliate links, meaning we get a commission if you decide to make a purchase. Read our disclosure.
