Forum Discussion
Thulasiram
Helper II
Helper IIBlank values
Dear all, I have a fact table with columns of products , customers and sales another table containing discount rates for each product. Mostly one customer has only one product but in some cases mor...
Thulasiram Not sure I fully understand but try using MAXX(FILTER( ) ) instead of LOOKUPVALUE
Step 1: I add a relationship between a fact table and another table. (Key column: 'product')
Step 2: I add a column to a fact table.
discount rates = RELATED(another table[discount rates])
mickey64
Super User
Super UserStep 1: I add a relationship between a fact table and another table. (Key column: 'product')
Step 2: I add a column to a fact table.
discount rates = RELATED(another table[discount rates])
ThulasiramHelper II
Helper IIThank you