Forum Discussion

zz99b0's avatar
zz99b0
Frequent Visitor
5 years ago

Best Practice for using same lookup tables across multiple fact tables

I need some guidance for best practices with lookup tables.  I’m learning Power BI and have done the best I can to search for examples, but I have not found a similar issue that I could translate to ...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

Generally you will want to unlearn the term "lookup table".  In Power BI it has the meaning of a table that is not connected to the data model.   You will want to let the data model do as much work as possible (including the use of USERELATIONSHIP for secondary joins)  and only resort to disconnected tables if absolutely necessary.  Read up on TREATAS() vs LOOKUPVALUE() too.