Power BI
Needs VotesIntelliSense Should Use Best Practice Column and Measure Naming Conventions
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)
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.
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.
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.
RE: IntelliSense Should Use Best Practice Column and Measure Naming Conventions
I am with you on this.