I'm looking for general advice for general tables in Excel, especially when they become very big and have calculated columns (I have sometimes seen 3-4 calculated columns iterating over 10,000 rows! Oh, I wish I had some idea how to split calculations from database).
How would I split (normalise the database) the "database" and "calculations" if one of my stakeholders needs the table with values?
I thought of the following options:
- Is Microsoft Access (for data) the alternative (don't know if you could add calculated columns as I am still learning access).
- Using DAX measures? How would one use DAX measure as alternative to vlookup calculated columns in Excel?
If you have any pointers on data normalisation for these chunky Excel tables, please share.