Forum Discussion
hgalfre
Helper I
Helper IRelationship with a dimension table that has several keys
Hi there! I have a few tables on my model. I managed to connect properly most of the tables (that are the classic types, like fact tables with orders or invoices and dimension tables with produc...
hgalfreHelper I
Helper IHi edhans!
Thanks for the update 🙂
I'll try to check your solutions.
About the 1st one, just to make sure I understood right; if I unpivot the client table, then I would get up to 4 lines per client, am I right?
So I would have this if I take my previous example:
| CN (client name, unique) | CC (client code, unique) | Key |
| Wholesale cars | 001 | GC_123 |
| Wholesale cars | 002 | CT_3 |
| Wholesale cars | 003 | GWC_002 |
Thanks!
edhans
Community Champion
Community ChampionThat is correct, and may or may not be acceptable in performance. Chris Webb's BI Blog: The Pros And Cons Of Modelling Measures As A Dimension In Power BI Chris Webb's BI Blog (crossjoin.co.uk) is a good writeup on the pros and cons of this approach.