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.

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.

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

325 votes
Sign in
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

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


Sign in
Sign in with: facebook google
Signed in as (Sign out)
  • 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.