Forum Discussion
My auto weekly inventory calculation stopped working.
I have a formula that automatically calcutes the change in inventory from one week to another. This formula worked for several weeks until recently. Our IT pushed an update to our Date Calendar (Di...
My first assumption was that this formula stopped working because of the switch from import mode to direct query. I just had IT switch only the DimDate table back over to Import Mode, and the problem still remains.
So, now i have the DimDate table in import mode and the FactInventory and all other tables in direct query.