Forum Discussion
Solved
Storing Tables with Calculated Columns as Static Tables
Hi, I'm working on a revenue forecast dashboard. The main table is Opportunity (with Id, Created Date, Close Date, Amount, etc. columns). I created several other tables from this table that aggre...
Short answer is no. Power BI has no memory.
Long answer: You can run DAX queries against a semantic model, even from within the Power Query Editor of that same semantic model. That is called Self Referencing. Use at your own risk. You will get a giant headache when you think about it too much. There is also no safety net.
lbendlin
Super User
Super UserShort answer is no. Power BI has no memory.
Long answer: You can run DAX queries against a semantic model, even from within the Power Query Editor of that same semantic model. That is called Self Referencing. Use at your own risk. You will get a giant headache when you think about it too much. There is also no safety net.
I'll read up on the self-referencing approach. Thank you for sharing.