How can we improve Power BI?

IntelliSense Should Use Best Practice Column and Measure Naming Conventions

There is a clearly defined and accepted best practice for referencing columns and measures in the DAX language.

1. Column names should ALWAYS reference the table name.
TableName[Column Name]
2. Measures should NEVER reference the table name.
[Measure Name]

This is a fundamental concept accepted by everyone with knowledge of the DAX language (everyone I know anyway).

IntelliSense in DAX sometimes follows this convention and sometimes it does not. I have created a short video (40 seconds) showing 3 examples. https://youtu.be/CvaRhKrnHRk

There are other places where column names are appended to measure names too, such as inside Quick Measures, and I have also seen Column Names used without pre-pending the table name.

Microsoft...
Please acknowledge that this is an issue, and
Please fix IntelliSense so it always follows the best practice

276 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Matt Allington shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    5 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Anonymous commented  ·   ·  Flag as inappropriate

        Also make naming conventions in power query without spaces so the inverted commas and hash aren't need.

      • Marshall Couch commented  ·   ·  Flag as inappropriate

        I thought maybe Power BI would let you create 2 measures with the same name as long as they have 2 different home tables, but it won't.

        What are the best practices for calculated columns?

      • Koen Verbeeck commented  ·   ·  Flag as inappropriate

        If this isn't implemented, we'll send all Power BI employees the YouTube video of Marco Russo jumping up and down screaming measures can't have table names. Every day.

      Feedback and Knowledge Base

      Ready to get started?

      Try new features of Power BI today by signing up and learn more about our powerful suite of apps.