Multiplication fonction year between two tables

[Romesss31]

Hello All,

I would like to multiply two tables depending on each year.

For example, I have a first table :

2024	01/2024	1
2024	02/2024	2
2024	03/2024	3
2025	01/2025	4
2025	02/2025	5
2026	2026	6

And a second table:

2024	10
2025	20
2026	30

I have a relation between both table with the year as reference.

I would like to create a global measure who permits to multiply correct value by year.

In this example, the result of the measure should be 420.

Can you please help me to find the correct measure please ?

Thank you very much for your help and have a nice day,

R

[lbendlin · Accepted solution]

[Romesss31]

Hello Ibendlin,

Thank you very much for your answer.

With a relation 1 to * between both table, this formular is working.

Have a nice day,

R