Forum Discussion
Blank 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 more than 1 product.
I have a dim table containing customer names.
I want to bring in the product name against each customer through lookupvalue function.
Since some customers has more than 1 prouduct, the result show error. I used IFERROR function
to show blanks in those cases where customer has more than 1 product.
I calculated discount amount by calculating sales from one table and discount rate from another table.
Since my dim table contains blank values for products against some customers, the rows contains
blank values but discount is properly calculated.
Is there any way I can bring in the product names?
Help is much appreciated.
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])
5 Replies
Thulasiram Not sure I fully understand but try using MAXX(FILTER( ) ) instead of LOOKUPVALUE
Thank, will try.
Hi,Thulasiram
Has the problem been solved? If it does, share your solution and accept it as a solution that will help other community members who have the same problem as you.
Best Regards,
Leroy Lu
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])
Thank you
