Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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]))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |