Sumif equivalent with several filter arguments & across tabels

[telsweil93]

Hello,

we work with employees' time data and need to create a relationship between the periods in addition to the relationship between the Local Personnel ID.

Unfortunately, this is not possible in the model. As a solution, we would like to add a sumif-function to the data model.

However, this function must allow several filter arguments (period, Local Personnel ID, time type (f.e. sickness)).

However, the sumif-functions I allready know only allow one filter argument.

CALCULATE(SUM('PTBAL00- Zeitkonten'[Anzahl Stunden]),FILTER(ALLSELECTED('PTBAL00- Zeitkonten'),'PTBAL00- Zeitkonten'[Local Personnel ID]=EARLIER('WFM alle Standorte'[Local Personnel ID])))

SUMX(FILTER('PTBAL00- Zeitkonten', 'PTBAL00- Zeitkonten'[Local Personnel ID]='WFM alle Standorte'[Local Personnel ID]),'PTBAL00- Zeitkonten'[Anzahl Stunden])

The aim is to have another calculated column in the "WFM all locations" table, which is calculated from the "PTBAL00 time accounts" table. In addition to the filter [local personnel ID], we also need a filter for time type and period.

Does anyone have an idea for a suitable function?

[v-zhangti]

Hi, @telsweil93 

Can you provide some sample data or simple pbix files? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@telsweil93 , Nor very clear to me. See if these can help

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8