today function

[BORUCH]

can someone guide me regarding power pivot automatic calculation vs manual recalculation, i currently have this calculated column, called "days overdue" in my power pivot table .

=IF(TODAY()-ARTABLE[AR DATE]<=30,"0-30 DAYS",IF(TODAY()-ARTABLE[AR DATE]<=45,"31-45 DAYS",IF(TODAY()-ARTABLE[AR DATE]<=60,"45-60 DAYS",IF(TODAY()-ARTABLE[AR DATE]<=90,"60-90 DAYS","OVER 90 DAYS"))))

but i realize that it doesn't update every day to the current date, only if i switch back to manual calculation mode ,and then click recalculate now, then it will update.

Even if i slice the column "days overdue" to lets say "31-45" it wouldn't recalculate how can i fix that ?

 

[Special-K99]

You should be able to replace that formula with the somewhat shorter

=LOOKUP(TODAY()-ARTABLE[AR_DATE],{0,30,45,60,90},{"LESS THAN 30","31-45","46-60","61-90","OVER 90"})&" DAYS"

 

[krrishkrsna]

SUPERB formula by Special-K99

 

[BORUCH]

superb formula by special-k99

hold on now

#1 i'm looking for a dax formula

not an excel formula

#2 i need something that will solve my recalculating problem