Forum Discussion
Multiply fields with a connection
Hey there I am very new to Power BI and tried so search a solution online but sadly did not find one (or I did not understand it maybe...). I have two table. Left every "Tarifgruppe" has around ...
eliasayyy
Memorable Member
Memorable MemberOk thank you for explaining can you send some sample data? And can a person id have different jobs?
2 seconds ago
| Tarifstufe | Tarifgruppe | difference between two dates |
| 00 | 12 | 100 |
| 01 | 21 | -150 |
| 02 | 22 | 200 |
| 03 | 23 | -500 |
| 04 | 24 | 600 |
Sorry had some days off so just got back. And the table is quite bad but I hope it explains it. I want to multiply the difference in the table above with the corresponding salaray below (e.g. 100*207'513 or -150*55'761).
The Tables are a lot longer and a person can have different jobs.
| below Tarifstufe, right Tarifgruppe | 12 | 21 |
| 00 | 207'513 | 195'638 |
| 01 | 205'924 | 55'761 |
| 02 | 105'140 | 66'763 |
| 03 | 90'277 | 62'812 |
| 04 | 152'042 | 162'675 |