Forum Discussion
Solved
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 Catego...
Well, this can be achieved this way:
Table 1 = SELECTCOLUMNS(Sales,"ProductID",Sales[ProductID],
"Discount",LOOKUPVALUE(Category[Discount],Category[Category],Sales[Category]))
Well, this can be achieved this way:
Table 1 = SELECTCOLUMNS(Sales,"ProductID",Sales[ProductID],
"Discount",LOOKUPVALUE(Category[Discount],Category[Category],Sales[Category]))