What are your measure naming conventions?

Hi @Jamie. I’d continue to use the short forms you already have, and replace others as appropriate, so, for example,

PY - previous year
PQ - previous quarter
PM - previous month
PW - previous (full) week
P2W - week before previous week
SDLW - same day last week
SWLY - same week last year
WTD - week to date
etc.

I’ve also found it quite useful to output the text of my measures using an external tool like DAX Studio or Tabular Editor, drop the text into a Word document, then work with that a bit to identify patterns that look good to you. You’re right that consistency is the goal, and I’d add (paraphrasing Matthew Roche), “make names as short as possible and as long as necessary”. As well, you can add a glossary page or info button tooltip to your report(s) that reads from a stand-alone Excel file listing all abbreviations and their “expanded” meanings, if that would help the end users.

Hope this helps.
Greg

2 Likes