two not related tables ,use one value in the other table and use that value to calculate new value

[Rene34324]

I have to views that are not related (and cannot be related)
They both have a month field,  the data is presented in tables like below:

month            field a (int)            month                       field b (int)
1                                                  1
2                                                  2
..                                                  ..
12                                               12
               table 1 (visual)                                    table 2 (visual)

I would like to have field b  availalble in table 1, the field b value should also be used in a measure to calculate a new value
in combination with values from table 1, that can be used to draw a line in a stacked column chart

How can i achieve this ?
Thank you.

  

[v-weiyan1-msft]

Hi @Rene34324 ,

If your problem is still not resolved, to allow us to better understand the problem and help you, can you share sample data and the results you are hoping for? Show it as a screenshot or excel. Or a sample pbix after removing sensitive data.

Best Regards,
Yulia Yan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Rene34324 · Accepted solution]

I resolved this by creating two views  with summed data and joined them on year,month

[Idrissshatila]

Hello @Rene34324 ,

try the following calculated column, adjust the table names and fields according to your data

column from table 2= 
LOOKUPVALUE (
    'table 2'[field b (int)],
    'table 2'[month],
    'table 1'[month],
)

[Rene34324]

@Idrissshatila

The tables 1 and 2 , are table/matrix visuals (updated this in the original question) i reffer too, with aggregated data(month) .
Are they accessible too by name ?