I don’t know if this is possible, but I’d like to create a table that builds with each refresh. Here’s what I’m thinking:
- I have a project DB that I pull in a table that has a toggle – active or non-active. Using that toggle, I can filter all measure to calculate on active projects only.
- Projects from the source DB are toggled from active to non-active and vice versa without a date being attached. So when I refresh, I get today’s active project but no context to how it may compared to yesterday
- Is it possible to create a table that is filled by a measure each day I refresh. The parallel is when using excel you copy a formula cell and you paste it as a number.
- Over time (as I refresh daily), I get a table that is built with a new row each refresh.
I want to calculate a measure each day based on the day’s refresh, and then store that measure as a number in a seperate table.
I hope that makes sense any feedback is greatly appreciated.