Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Calculate unique viewership duration

hi,   I have that captures viership of media/video content like netflix shown in table below. Row 1 captures viewership of customer "123456" watching video "Short Movie 2" that is 240 secs in durat...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
6 years ago

mahoneypat how do i ensure i dont include the overlap in duration?

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Did you try the SUMX measure?  It calculates the difference on each row and then sums up the results, so should avoid overlapping values.

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    mahoneypathowever there will be overlap in duration between each row.