Forum Discussion
jeanilieski
3 years agoFrequent Visitor
Remember date when Boolean changes from "FALSE" to "TRUE"
Hi. I have a table with many Bolean columns. The columns are based on crm data and they will change every day. I would like to be able to remember the date when the value will change from "FALSE" to ...
- 3 years ago
If that is where your data comes from, yes.
lbendlin
Super User
3 years agoPower BI has no memory* . You need to manage your snapshots in the upstream system. * Yes, there is the self referencing option but that has no safety net.
jeanilieski
3 years agoFrequent Visitor
Hi Ibendlin, thank you for your answer. Sorry, but I do not undersatnd what you mean by 'upstream system'. Could you please tell me if it is possible to somehow save (maybe to "fix" or to "block" is a better expression) the date of the change in a special table? Thanks!
- lbendlin3 years ago
Super User
"upstream system" means you have to do that outside of Power BI - before your data is loaded into Power BI.
- jeanilieski3 years agoFrequent Visitor
Hi Ibendlin, "outside of Power BI": does that mean that I could achive this in SQL Native Query?
- lbendlin3 years ago
Super User
If that is where your data comes from, yes.