Forum Discussion

vsinne's avatar
vsinne
Frequent Visitor
8 years ago
Solved

Merge rows contain different time values

Hello,   I have this database where all the agents are filling their time as and when they perform any task in the given ID #. This is resulting in duplication of ID# as shown below and their uniqu...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Or are you trying to get the following results vsinne?

     

     

    TableName = 

    SUMMARIZE (
        sourceTable,
        sourceTable[ID],
        sourceTable[Agent Name],
       "Total Time", SUMX(DISTINCT(sourceTable),sourceTable[Time in Seconds] )
    )

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Or are you trying to get the following results vsinne?

 

 

TableName = 

    SUMMARIZE (
        sourceTable,
        sourceTable[ID],
        sourceTable[Agent Name],
       "Total Time", SUMX(DISTINCT(sourceTable),sourceTable[Time in Seconds] )
    )

 

vsinne's avatar
vsinne
Frequent Visitor
8 years ago

Yes, this is the result i am expecting to yield. how can i merge those rows that has just the duplicate values? thank you so much for your help.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    vsinne, in Data view click on (1)create a New Table from the Modeling ribbon then (2)use the DAX formula I provided on my previous post.