I am very new to Power BI Desktop, and am looking for some help with an added column. I have two tables in my model, and I am looking for the equivalent of a SumIFS based on 3 criteria matching between the two sheets. Table 1(Workplan Summary) is a list of all emplyee, their project, and week ending, with a number for the hours they should spend in those weeks.
Table 2(Timesheet Data) is a data dump from a timekeeping system where they enter the time they spend every week. I need to take the sum of data in table 2, matched on the employee name, week ending date, and the project name, and have that value in a new column in table 1, so that the data can be represented and filtered properly with slicers. I read through some threads here and came up with the following formula, and it is returning no values. Can anyone point out where there might be some issues?
Actual Hours = SUMX('Timesheet Data',IF(AND('Timesheet Data'[Activity]='Workplan Summary'[Project Number],AND('Timesheet Data'[Description]='Workplan Summary'[Resource],'Timesheet Data'[End Date]='Workplan Summary'[Week Ending])),CALCULATE(SUM('Timesheet Data'[Quantity])),BLANK()))