Forum Discussion
bergen288
Helper IV
3 years agoUse DATEDIFF function to calculate session gap between previous end time and current start time
I have a table visual as shown below where Created_TS is the session start time and Created_TS_End is session end time. I would like to use DATEDIFF function to calculate session gap between previou...
bergen288
Helper IV
3 years agoMy data is pretty large one over 710,000 rows. It takes very long time to create the new column (still waiting for it). I believe a measure should have a much better performance as it will be used with a selected case via drill-through. So I tried to define the following measure, but it gives me an error. The root cause should be the 1st row which won't have previous (earlier) value. How to address it?
Thanks.