Calculate second filtered by text column

[FRG]

Hi,

In this table I have 2 users that are in place a period of time. The "PremierUserDel" is in place the number of seconds in the column "WorkingTimePremierUser".
The "DeuxiemeUserDel"  is in place the number of seconds in the column "WorkingTimeDeuxiemeUser".

The expecting result for the time in place for each user for this period of time should be:

Marc                      3600

Micky                     8100

Pier-Luc                 3600

Danny                    3300

Autre equipe jour  7800

Xavier                     3600

How to calculate that?
Thanks

[v-piga-msft · Accepted solution]

Hi @FRG ,

We could achieve your desired output in two ways: Dax and Power query.

First way: you could create the calculated table to achieve it.

Table =
UNION (
    SELECTCOLUMNS (
        'Table1',
        "user", 'Table1'[DeuxiemeUserDel],
        "workingtime", 'Table1'[WorkingTimeDeuxiemeUser]
    ),
    SELECTCOLUMNS (
        'Table1',
        "user", 'Table1'[PremierUserDel],
        "workingtime", 'Table1'[WorkingTimePremierUser]
    )
)

The second way, you could use append query under Query Editor.

1. Duplicate the table and then remove the columns don't need.

2. Rename the name to be the same for the two table and then click Append Queries.

More details, please refer to my attachment.

Here is the output.

Best  Regards,

Cherry

[FRG]

Thanks! That works!