Forum Discussion
Function Related doesn't seem to work
Hey guys, Im working on a formula that calculates the amount of hours between 2 dates based on working days. I've been wachting a clip on how to do that and i'm using this formula Doorloopt...
lbendlin in your formula there is a part : GeneratesSeries(0,1439)
However seeing that my data has 2 years worth of dates and if I make a MinuteCalendar that table would have 1.051.200 rows I don't think that does wonders for the performance right ?
Ive already tried change the value tot a 1.051.200 but my laptop is still busy .... hhaha
As I said before, a MinuteCalendar is not required any more. Only the intervals are considered (cardinality reduction), so that will be faster. But you can try materializing that table. There's no good reason to recreate it for every row (other than that the code looks slicker).