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
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

For your overlap periods you can either deploy an EXCEPT function, so that the duration would be 

 

(A EXCEPT B ) + B

 

but that would require you do decide on a granularity ( i guess you already settled on seconds) and then generate series on the fly.

 

The alternative would be to realize that Power BI is not the right tool for your requirement.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    lbendlinwhat would be A and B in the formula you mentioned? And, what tool would you suggest instead of PowerBI