Nathan,
There is no real normal time frame in which a DI cartridge will last. For example, I personally know people who've gotten over 1000 gallons out of a quality DI, then there is me, who gets only 100 gallons. My source water is laden with high CO2,which passes right through an RO unit and is gobbled up by the DI.
I've never been a fan of the color change DI's since exhaustion is subjective. Spectrapure units often come with Electronic Purity monitors which measure the conductivity of the water. Conductivity is directly related to the # of ions in the water. "Pure" water, (H20, and that's it) has 0 conductivity. I run a double DI system after my RO so that if I fail to catch the exhausted DI cartridge, my second cartridge catches any waste products. I can produce water of "0" conductivity using this method.
FWIW, once a DI is exhausted, it will quickly release the most weakly chemically bound ions, which just happen to be Silicates and Phosphates !!
I hope this helps.
John