Forum Discussion
vgdits
7 years agoFrequent Visitor
Multiplying measure between tables
Hi, after several failed attempts or very unhandy solutions I would love to ask for advise. I am trying to use PBI to revaluate stock. Having product table with currency, transactions table wi...
v-juanli-msft
Community Support
7 years agoHi vgdits
The matrix in your screenshot is your expected result or actual result?
What have you done in your pbix, could show me a screenshot to know which columns or measures you add in "row","column" and "value" field of the matrix?
the YM column should show year/month from 2001/1 to 2001/12 (12 months), right?
Based on my testing, you may need to cretae a new table with power query or a new calculated table with DAX, since adding a new calculated table to the model may slow the performance, please let know how large is your real dataset so i can choose a better way to slove this problem.
Best Regards
Maggie