cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vyacheslavg Helper II
Helper II

Naming fields in analytics

Hello, 

 

Could you please advise a good method to name fields in analytical data modeling?

 

For example, I have CustomerID in Customers and Orders tables.

 

In production database these names are the same (CustomerID in Customers and the same in Orders).

 

In analytical datamodel I want to differentiate these Ids, because it gets very confusing (at least to me).

 

For example, several approaches.

 

Customers-CustomerID and Orders-CustomerID

 

Another approach

 

CustomerID.Customers and CustomerID.Orders

 

In another words, I want to preserve the table name (full resolution), and in some cases even database name, like CustomerID.Customers.Accounting and CustomerID.Customers.Marketing

 

Otherwise it is getting pretty confusing in reports to understand to what database, table or file this field is from.

 

Maybe I'm on a wrong path here? Any suggestions or links to common practice would be appreciated.

 

 

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
davehus Resolver I
Resolver I

Re: Naming fields in analytics

2 REPLIES 2
davehus Resolver I
Resolver I

Re: Naming fields in analytics

Highlighted
vyacheslavg Helper II
Helper II

Re: Naming fields in analytics

Hi Dave, 

 

this is great.

It shows that PBI master is using the same technique for something in her workflow.

And there is even the M function to simplify this stuff.

Very useful indeed, thanks.

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors