Forum Discussion
AlB
Community Champion
Community ChampionOptimizing search for simultaneous logins - Slow measure
Hi all,
We have a Sessions table that registers logs into a system:
SessionID
CardNumber
StartDateTimeEq
EndDateTimeEq
1
100
01/09/20 09:35
01/09/20 10:18
2
102
...
Yes.
I tried calculated column with 520k+ rows, it takes 1min or so to load and calculate; I think it's worthwhile. On one hand, the attribute of a specific session is static; on the other hand, measures to slice and dice the data model on the fly takes a blink of an eye only.
AlBCommunity Champion
Community ChampionThanks CNENFRNL
So what would be the result of simultaneous logins in the table above? the sum of sessions that are non-primary?
CNENFRNLYes.
I tried calculated column with 520k+ rows, it takes 1min or so to load and calculate; I think it's worthwhile. On one hand, the attribute of a specific session is static; on the other hand, measures to slice and dice the data model on the fly takes a blink of an eye only.