Forum Discussion
Create a table from existing relationship
Hi.
I can create a table visual from two related tables. But how can I create a table from them? For example, I have two related tables:
Category Sales
Category Discount Category Date ProductID Amount
A 10% A ... 123 100
B 20% B ... 124 200
A ... 123 50
I need a table (not visual), that includes ProductID and Discount. I need to construct such table because I then need to crossjoin it with another table.
Well, this can be achieved this way:
Table 1 = SELECTCOLUMNS(Sales,"ProductID",Sales[ProductID],
"Discount",LOOKUPVALUE(Category[Discount],Category[Category],Sales[Category]))
1 Reply
Well, this can be achieved this way:
Table 1 = SELECTCOLUMNS(Sales,"ProductID",Sales[ProductID],
"Discount",LOOKUPVALUE(Category[Discount],Category[Category],Sales[Category]))