Forum Discussion
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...
lbendlin
Super User
Super UserFor 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.
lbendlinwhat would be A and B in the formula you mentioned? And, what tool would you suggest instead of PowerBI