Forum Discussion

EnrichedUser's avatar
EnrichedUser
Helper III
5 years ago

Reference Virtual Table - Value Between Two Times

Hi All,    I have a virtual table _Table = GENERATE( SUMMARIZECOLUMNS(ActivitySheet[StartTime2], ActivitySheet[EndTime2], ActivitySheet[UserID], ActivitySheet[TransactionType], ActivitySheet[Bran...
Need Help
EnrichedUser's avatar
EnrichedUser
Helper III
5 years ago

I was able to get it working using the below messure and making the table a calculated table instead of a virtual one

Working Segment = 
IF(COUNT('Test 2'[Time])>0,
1,
BLANK()
)

 

It nearly doubled the size of my file and is not a great long term solution.