skip to main content
Power BI
    • What is Power BI
    • Why Power BI
    • Customer stories
    • Data visuals
    • Security
    • Power BI Desktop
    • Power BI Pro
    • Power BI Premium
    • Power BI Mobile
    • Power BI Embedded
    • Power BI Report Server
  • Pricing
    • Azure + Power BI
    • Microsoft 365 + Power BI
    • Dynamics 365 + Power BI
      • Energy
      • Healthcare
      • Manufacturing
      • Media
      • Retail
    • For analysts
    • For IT
      • Overview
      • Embedded analytics
      • Power BI visuals
      • Automation
      • Documentation
      • Community
    • Partners Overview
    • Solutions Partners
    • BI Specialized Partners
    • Power BI CSOs
    • Fabric Partner Community
    • Training
    • Getting started
      • Overview
      • Self-guided learning
      • Webinars
      • Documentation
      • Roadmap
      • Overview
      • Issues
      • Give feedback
    • Blog
    • Business intelligence topics
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • Events
    • User groups
    • Community blog
    • Register
    • ·
    • Sign in
    • ·
    • Help
    Go To
    • Power BI forums
    • Updates
    • News & Announcements
    • Get Help with Power BI
    • Desktop
    • Service
    • Report Server
    • Power Query
    • Mobile Apps
    • Developer
    • DAX Commands and Tips
    • Custom Visuals Development Discussion
    • Health and Life Sciences
    • Power BI Spanish forums
    • Translated Spanish Desktop
    • Power Platform Integration - Better Together!
    • Power Platform Integrations
    • Power Platform and Dynamics 365 Integrations
    • Training and Consulting
    • Instructor Led Training
    • Galleries
    • Community Connections & How-To Videos
    • COVID-19 Data Stories Gallery
    • Themes Gallery
    • Data Stories Gallery
    • R Script Showcase
    • Webinars and Video Gallery
    • Quick Measures Gallery
    • 2021 MSBizAppsSummit Gallery
    • 2020 MSBizAppsSummit Gallery
    • 2019 MSBizAppsSummit Gallery
    • Events
    • Ideas
    • Custom Visuals Ideas
    • Issues
    • Issues
    • Events
    • Upcoming Events
    • Community Engagement
    • T-Shirt Design Challenge 2023
    • Community Blog
    • Power BI Community Blog
    • Custom Visuals Community Blog
    • Community Support
    • Community Accounts & Registration
    • Using the Community
    • Community Feedback
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 

    Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

    • Power BI forums
    • Galleries
    • Data Stories Gallery
    • DAX Reference

    DAX Reference

    07-02-2019 06:13 AM - last edited 01-30-2021 14:54 PM

    Kieran
    Advocate II
    2849 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    Kieran
    Kieran Advocate II
    Advocate II
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    DAX Reference

    ‎07-02-2019 06:13 AM
    Overview
    Learning a new language can be over-whelming. Within the Data Analysis eXpression (DAX) language there are many different commands. However it is quite possible to create a professional Power BI solution using a small sub set of the commands available. Where this small sub set of DAX commands together have a much more manageable learning experience.
    There are two types of best practice to keep the usage of DAX as simple as possible …
    •         Aim for your data model to be a star schema.
    •         Perform as much transformation within the data load process as possible, either in Power Query (for Power BI) or SSIS for Analysis Services Tabular Model.
    If you follow the above best practices in full you will be very pleased as to how many insightful and attractive data visualisations you can easily create within a very short period of time.
    The examples are included within the sample AdventureWorks PowerPivot and AdventureWorks PowerBI solutions so you can gain a greater context of the example code against each function description. Please click on the following link to examine these data models.
    There is also a DAX query script where some example code is executed within the context of a DAX query as instead of a column or measure within a model. Please download DAX Studio https://daxstudio.org/ to view / analyse and run the DAX query scripts.
     

    Training

    Details of training on Power BI is available from https://www.dataplatformservices.com/

     

     

    eyJrIjoiYzQ0ZjJmYzItNTNlZi00YmFlLWFlMDAtOTA3MjYwMjlkYzYzIiwidCI6ImY1NmM4YzIyLTQ5ZDMtNDQ5OC1iZThiLWU3MWE0YjVlZGRjNiIsImMiOjh9&pageName=ReportSection

    Preview file
    12 KB
    Labels:
    • Labels:
    • How To
    Message 1 of 2
    2,849 Views
    4
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    PBI-Padawan
    PBI-Padawan
    Frequent Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎12-26-2020 03:53 AM

    This is well done. I haven't seen the DAX Reference shown in this way before.

    Message 2 of 2
    1,653 Views
    1
    Reply

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Pages
    • Power Automate
    • Power Virtual Agents

    • Sign in
    • Sign up

    Browse

    • Solutions
    • Partners
    • Consulting Services

    Downloads

    • Power BI Desktop
    • Power BI Mobile
    • Power BI Report Server
    • See all downloads

    Learn

    • Guided learning
    • Documentation
    • Support
    • Community
    • Give feedback
    • Webinars
    • Developers
    • Blog
    • Newsletter

    © 2023 Microsoft

    Follow Power BI

    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks
    Consumer Privacy Act (CCPA) Opt-Out Icon Your Privacy Choices