Relationship between Channel Views and Programme

Hi zac_lim,

As Baskar said, it is hard to create the relationship between these tables. In my opinion, you can use dax to get the specific value.

If the views means the current total views amount, you can try to use below formula if it suitable for your requirement:

Measure formula:

Views=
var currChangel=LastNoBlank(Table2[Channels],[Channels])
var CurrStartTime= Max(Table2[StartTime])
var CurrEndTime=Max(Table2[EndTime])
var temp=Filter(All(Table1),Table1[Channel]=currChangel)
return
Maxx(filter(temp,AND(Table1[Time Interval]>=CurrStartTime,Table1[Time Interval]>=CurrEndTime)),Table1[Views])

Regards,

Xiaoxin Sheng