If Help

Hello, I am having isues with creating a new column using mutiple columns with an IF statement. I am looking to do something like this If timeissue = good and week = 1 then sum actual hours, ...

Need Help

Anonymous
6 years ago
Anonymous

Result =
SWITCH (
    [Time Issue],
    "Good", SWITCH (
        Sheet1[Week],
        1, FORMAT (
            CALCULATE ( SUM ( Sheet1[Acutaul Hour] ), FILTER ( Sheet1, Sheet1[Week] = 1 ) ),
            BLANK ()
        )
    ),
    "Missing Timesheet", "Missing Timesheet"
)

Paul

Forum Discussion

If Help