Forum Discussion
division between tables
Good morning, I have been searching through the posts and did not find an answer to my problem.
I have two tables related by date, and I want to make a division between the related values of one table and the other, but I do a count and I count all the rows, not the related ones.
Thanks in advance
1 Reply
ireferpesaRS , You can have measure like this and view it across common dimenions
divide(Sum(Table1[COlumn]), count(table2[COlumn]) )
If you need to copy data from one table to another refer to these
refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
