counting days

[Fiala]

Hellou, I have a problem with calculated column.
I have created this:

in how many days =

var val = 'Tab1'[Calling_Number]

var thisdate = 'Tab1'[CC_Call_Start_Day]

var nextdate = CALCULATE(min('Tab1'[CC_Call_Start_Day]),ALLEXCEPT('Tab1','Tab1'[Calling_Number]),'Tab1'[CC_Call_Start_Day]>thisdate)

var daysCount = CALCULATE(DATEDIFF(thisdate,nextdate,DAY),'Tab1'[Calling_Number]=val)

return

daysCount

But the result is wrong. I have a problem if calling_Number calls more then one a day.

I have 2 million lines in the feed, so I'd rather avoid the value of time. It's very slow.

[Fiala]

@amitchandak Thank you. I added an INDEX column. But I don't know how to use it. I need to calculate the difference between two dates, so I have to use dates as well. The date column also has time, but when I work with time, the calculation stops when there is not enough memory.

[amitchandak]

@Fiala , does calling CC_Call_Start_Day has timestamp(some other date), if not add an index column and use it (Use in place of date)

https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi

Column will slow as this will this as column at the load time, but post that it should be fast.