Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Blogging Freelancing Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Business Business Analytics & Intelligence DAX

Power BI DAX secrets - (Learn DAX formulas for Power BI)

Mastering DAX Power BI step by step. A complete training to learn Microsoft Power BI DAX from basics to advance.
Rating: 4.0 out of 54.0 (178 ratings)
28,018 students
Created by Data Chunks
Last updated 1/2021
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • You will learn core concepts of DAX (Data Analysis Expressions)
  • How to write DAX formulas
  • How context works in Power BI that include Row context & Filter context
  • What is context transition in Power BI
  • Secrets of magic function Calculate and its practical usage
  • Aggregated & Table functions
  • How to deal with relationships in Power BI
  • Error handling
  • Time intelligence functions in Power BI

Requirements

  • Students should have little bit knowledge about Power BI, Excel etc.
  • You need to download latest version of Power BI(free)
  • You should have the right pasion & willingness to learn DAX and practice.

Description

What is DAX in Power BI?

DAX stands for Data Analysis Expressions i.e. such expressions or formulas that are used for data analysis and calculations. These expressions are a collection and combination of functions, operators, and constants that are evaluated as one formula to produce results (value or values). DAX formulas are very useful in BI tools like Power BI as they help data analysts to use the data sets they have to the fullest potential.


Why learn DAX is important?

Learning DAX is essential to build dynamic dashboards.  It uses in Power BI desktop, SQL Server Analysis Services (Tabular mode), and Microsoft Excel. It is a formula language that needs tables to perform calculations.


Soul of Power BI
The core of learning Power BI DAX is its context. There are two types of contexts, the first one is the filter context, and the second one is the row context. These context works together whenever you write any dax expression. I will explain these contexts with the help of simple examples. If you have solid concepts regarding filter context, row context, and context transition, then you can solve any complexity quickly.


With the help of the DAX language, analysts can discover new ways to calculate data values they have and come up with fresh insights.

In this course, you will learn the core concepts of dax language. For the simple dashboards, you can get your results without writing single dax formula but for the advanced calculations, you really need to learn dax with its core concepts.

DAX is a really easy language to write but a bit hard to grasp in the beginning. Once you learn DAX underlying theory then it is easy to write any formula and you can play with multiple nested contexts.

With every topic, first, we will discuss hidden concepts and then we will do its implementation.

About me

I am your instructor Muhammad Asif Microsoft certified solutions expert in data management & Analytics. I have more than 10 years of experience in Microsoft BI stack with world-leading financial Firm. You will learn what exactly is used in the industry.


let's proceed to learn the secrets of DAX

Who this course is for:

  • Data Analyst, BI Developers, Power Users, Data Engineers, Business Intelligence

Course content

4 sections • 49 lectures • 4h 58m total length

  • Preview01:32
  • How to import data into Power BI
    07:19
  • Data types in Power BI
    03:55
  • Calculated Columns
    09:33
  • Preview07:53
  • Logical functions & Operators
    12:34
  • Error handling
    06:47
  • Aggregation functions
    05:06
  • Variables in DAX
    07:46

  • Filter context
    09:53
  • Row context
    07:39
  • Filter function in DAX
    08:58
  • Filter function with ALL
    07:00
  • Allselected function in DAX
    04:10
  • Ranking using DAX variables
    11:57
  • Preview06:11
  • Related vs Relatedtable functions in DAX
    05:56
  • calculate function to change the filter context
    07:17
  • Power BI calculate with ALL to ignore the filter context
    05:45
  • Power BI Calculate with Allselected
    05:27

  • Power BI Calculate with filter function
    02:51
  • Power BI keepfilters function in DAX
    08:00
  • Power BI nested calculate
    04:34
  • Power BI Count vs Counta functions
    05:05
  • Power BI Countrows, Distinctcount and Countblank
    06:25
  • DAX HASONEVALUE and SELECTEDVALUE functions
    08:20
  • HASONEVALUE vs HASONEFILTER function in DAX
    05:21
  • Alternative of Hasonevalue function using Countrows function
    03:17
  • Power BI Values function
    03:36
  • Context transition in DAX
    03:30
  • Automatic context transition in DAX
    02:32
  • Preview04:37

  • Calendarauto function in DAX
    12:08
  • DATESBETWEEN function in dax
    11:09
  • DATESYTD function in dax
    05:18
  • Parallelperiod in Power BI
    04:54
  • Sameperiodlastyear in Power BI
    03:28
  • Power BI Coalesce function in DAX and SQL
    05:39
  • Firstnonblank function in DAX
    05:42
  • Lastnonblank function in DAX
    05:44
  • FirstnonblankValue function in DAX
    05:24
  • Lastnonblankvalue function in DAX
    05:19
  • IsFiltered vs IsCrossedFiltered function in DAX
    05:27
  • Generate function in DAX with TopN
    05:54
  • Advance usage of Variables in DAX
    04:06
  • How to handle missing relationship in the model
    02:12
  • Userelationship function to handle inactive relationship
    02:56
  • How to create Hierarchies in Power BI
    03:52
  • ISINSCOPE and percentage over hierarchies calculation
    08:26

Instructor

Data Chunks
Senior Data Analyst
Data Chunks
  • 4.1 Instructor Rating
  • 209 Reviews
  • 33,628 Students
  • 4 Courses

I am Muhammad Asif Microsoft® Certified Solutions Expert- Data management and analytics with more than 10 years of experience in the field of business intelligence & Data analytics.

My expertise lies in assessing complex business requirements, compiling market and trend data, designing and testing software to accelerate efficiency and revenue growth. I have expertise in Microsoft Business Intelligence stack, visualization & analytical tools like SSRS and Power BI to analyse massive dataset. Analyses datasets with the help of python and DAX programming to extract actionable insights that will help drive business decisions.

I have completed M.Sc. in Computer Science from Linköping University, Sweden in order to augment my qualifications. With a proven track record of successfully aggregating business data and developing solutions to improve business processes, I am confident to teach my students and can deliver ground level industry knowledge & expertise.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.