Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

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

Anonymous

Not applicable

6 years ago

Anonymous

Just try use the provideded to create a calculate column.

Best,
Paul

Anonymous

Not applicable

6 years ago

Hello,

The formual is working but it is summing all of the hours for week 1 in all of the columns that correlate to good. I need this to sum individually for each person in week 1. Not overall. Essentially I am calculatiing week 1 based on the week of the month. So fi we using this current month of November for example today 11/25/19 would be week4. Maybe I need to do this as a Measure so it will calculate based on the week within the month? Any suggestions?

Anonymous
Not applicable
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