Forum Discussion
Romesss31
1 year agoNew Member
Multiplication fonction year between two tables
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