Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
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]))
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |