Forum Discussion
Lookup description for code
I have a few tables that contain a "short code" for some fields (such as status, type etc). I have another table that contains all the codes, that I would like to lookup against. For example, one...
do you want to use it in a measure or calculated column?
you could try with TREATAS
https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/
or do LOOKUP on a table with FILTER for a specific CodeType
or if it's guaranteed that the same code cannot be in both Type and Status then you could just do join on the [Code]
you could also guarantee that by creating columns with values like
STATUS_LDG
TYPE_IND