Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Total Working Hours (repeating rows)

Hi all, I have a similar table:                                     As you can see, there are many rows for one worker and one date. The problem is that worker A for example...
Need Help
Show and Tell
Tips and Tricks
  • popov's avatar
    popov
    8 years ago

    Hello, Anonymous
    Try this formula

    Working Hours =
    SUMX (
        ADDCOLUMNS (
            SUMMARIZE ( Table[Date], Table[Date], Table[Worker] ),
            "WorkHoursByWorkerAndDay", CALCULATE ( MAX ( Table[Hours] ) )
        ),
        [WorkHoursByWorkerAndDay]
    )

    If you have Calendar (Date) table and relationship between Table and Calendar, use this formula

    Working Hours =
    SUMX (
        ADDCOLUMNS (
            SUMMARIZE ( Table[Date], Calendar[Date], Table[Worker] ),
            "WorkHoursByWorkerAndDay", CALCULATE ( MAX ( Table[Hours] ) )
        ),
        [WorkHoursByWorkerAndDay]
    )


popov's avatar
popov
Resolver III
8 years ago

Hello, Anonymous
Try this formula

Working Hours =
SUMX (
    ADDCOLUMNS (
        SUMMARIZE ( Table[Date], Table[Date], Table[Worker] ),
        "WorkHoursByWorkerAndDay", CALCULATE ( MAX ( Table[Hours] ) )
    ),
    [WorkHoursByWorkerAndDay]
)

If you have Calendar (Date) table and relationship between Table and Calendar, use this formula

Working Hours =
SUMX (
    ADDCOLUMNS (
        SUMMARIZE ( Table[Date], Calendar[Date], Table[Worker] ),
        "WorkHoursByWorkerAndDay", CALCULATE ( MAX ( Table[Hours] ) )
    ),
    [WorkHoursByWorkerAndDay]
)