Forum Discussion
Multiply two tables
Hi All,
I am trying to determine work allocation based on the information given in the below tables.
Table 1 has three columns
Table 2
What I want to achieve is when I select like "GA 10.1" on the slicer then a table must be created which gives how much portion of work will be completed end of each calender Year
like
2018 0
2019 0
2020 1001011*10%*(9/12)= 75076
2021 (1001011*10%*(3/12))+(1001011*20%*(9/12))
and so on
5 Replies
- Greg_Deckler
Community Champion
Well, I did create an MMULT Quick Measure:
https://community.powerbi.com/t5/Quick-Measures-Gallery/MMULT/m-p/630231
- baronraghu
Helper III
Can you please help me on how to use it in my query
- Greg_Deckler
Community Champion
If you do it in your query it won't be dynamic. If that is OK, ImkeF is probably the best person to help out. You could do the same thing MMULT is doing, transpose the 2nd table adn then merge it.
- Ashish_Mathur
Super User