Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
I want to add another column in table 1 by multiplying values from table2. How can I achieve this?
Go to Solution.
Hi, @sam_nik12345 ;
You could create a column as follows:
Column = [value]* CALCULATE(SUM('Table (2)'[value]),FILTER('Table (2)',RANKX('Table (2)',[index],,ASC)= RANKX('Table',[month],,ASC)))
The final output is shown below:
If you multiply the rows of the first table by the rows of the second table, how can you determine which row is the corresponding row.can you tell me your logic?
Best Regards,Community Support Team_ Yalan WuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
@sam_nik12345 , You can what is the basis of joining
You can have like
New column in Table 1 = [value] * sum(Table2[value])
of refer the ways to connect the table with each other
refer 4 ways to copy data from one table to anotherhttps://www.youtube.com/watch?v=Wu1mWxR23jUhttps://www.youtube.com/watch?v=czNHt7UXIe8
This formula New column in Table 1 = [value] * sum(Table2[value]) is working but it is multiplying sum(table2) with each row of table1.
I want to create a column with row * row from the tow tables. Can you you please suggest?
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.