Good
Microsoft Power BI DAX from Scratch
Hands-on guide to Microsoft Power BI DAX
Microsoft Power BI,Business,Business Analytics & Intelligence
Lectures -38
Resources -9
Duration -3 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course 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
Goals
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
Prerequisites
Power BI desktop installed
A basic understanding of Power BI desktop
Know how to create data models
![Microsoft Power BI DAX from Scratch Microsoft Power BI DAX from Scratch](https://d3mxt5v3yxgcsr.cloudfront.net/courses/8419/course_8419_image.jpeg)
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
3 Lectures
-
Getting started 02:21 02:21
-
Syntax 04:40 04:40
-
Introduction to DAX 01:48 01:48
DATE and TIME Function
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
TEXT Function
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
LOGICAL Function
6 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
RELATIONSHIP Function
3 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
X FUNCTION
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
FILTER Function
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
STATISTICAL Function
3 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
TIME INTELLIGENCE Function
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
INFORMATION Function
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
New Table And Quick Measure
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![Navya Kannan](https://www.tutorialspoint.com/assets/profiles/463795/profile/200_647904-1654496477.jpg)
Navya Kannan
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
Feedbacks
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now![Annual Membership Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)