Skip to main content

Power BI

Needs Votes

IntelliSense Should Use Best Practice Column and Measure Naming Conventions

Vote (341) Share
Matt Allington's profile image

Matt Allington on 28 Mar 2018 05:28:03

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

Comments (4)
Matt Allington's profile image Profile Picture

81ce4dee 9a3a-4f38-98cd-2bc49c0c5fa2 on 05 Jul 2020 23:17:58

RE: IntelliSense Should Use Best Practice Column and Measure Naming Conventions

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

Matt Allington's profile image Profile Picture

eb707c29 4c3f-4b1b-b6d6-0462871f2b36 on 05 Jul 2020 23:16:35

RE: IntelliSense Should Use Best Practice Column and Measure Naming Conventions

This is an issue. I hope Microsoft will address and fix this issue!! Thank you.

Matt Allington's profile image Profile Picture

7a521a13 45be-4ab3-9818-e5859573b464 on 05 Jul 2020 23:16:33

RE: IntelliSense Should Use Best Practice Column and Measure Naming Conventions

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.

Matt Allington's profile image Profile Picture

1d3ef26e 4a2d-4a13-add1-225f1ff2d898 on 05 Jul 2020 23:16:28

RE: IntelliSense Should Use Best Practice Column and Measure Naming Conventions

I am with you on this.