Forum Discussion
Milchmaa
3 years agoRegular Visitor
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 ...
Milchmaa
3 years agoRegular Visitor
Really appreciate it.
3 tables which I connected through a relationship and the table which you see on the right (salary table) is a new one with no connection yet.
Well let me try to explain it, the column Tarifgruppe is about the job. (12 could be carpenter, 13 could be chef) and column Tarifstufe is the level of experience (e.g. up to 20) and of course there are a lot of people on the list. On the right is the corresponding salary table.
Problem is I have a lot of people and possibilities which job and experience they have and now I want to calculate it for each job and experience.
eliasayyy
Memorable Member
3 years agoOk thank you for explaining can you send some sample data? And can a person id have different jobs?