topic Re: Multiply fields with a connection in DAX Commands and Tips

Multiply fields with a connection

Milchmaa — Mon, 31 Jul 2023 11:03:50 GMT

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 30 "Tarifgruppe". I want to multiply the value "Arbeitszeitanteil" with the corresponding field from the table left. Is this actually possible?

Many thanks already.

Re: Multiply fields with a connection

eliasayyy — Mon, 31 Jul 2023 11:07:11 GMT

im not sure i understood but please try

Measure = CALCULATE( 'Table'[Tarifgruppe] * 'Table'[Arbeitszeitanteil]),ALLEXCEPT('Table','Table'[Tarifstufe]))

Re: Multiply fields with a connection

Milchmaa — Mon, 31 Jul 2023 11:41:26 GMT

I got an error with "Tarifgruppe" as there are various numbers. (it goes on with e.g. 20, 21...).

For example Tarifstufe 1 and Tarifgruppe 12 but also Tarifstufe 1 with Tarifgruppe 20.

Similar the right table. You know what I mean?

Re: Multiply fields with a connection

eliasayyy — Mon, 31 Jul 2023 12:23:21 GMT

Im not sure im understanding i will ask questions if it not a problem

How many tables do you have

If more than 1 , are they connected through a relationship?

What is your expected results

Re: Multiply fields with a connection

Milchmaa — Mon, 31 Jul 2023 12:52:31 GMT

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.

Re: Multiply fields with a connection

eliasayyy — Mon, 31 Jul 2023 13:01:59 GMT

Ok thank you for explaining can you send some sample data? And can a person id have different jobs?

Re: Multiply fields with a connection

Milchmaa — Fri, 04 Aug 2023 09:54:55 GMT

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