Forum Discussion
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 "TRUE". The date has to be stored, however (not to be dynamic). This means that once the value for certain row turns into TRUE, and the current date is saved in my new column, the next time the PowerQuery/DAX will evaluate the same row, it will not overwrite the remembered date.
Thanks for your help!
If that is where your data comes from, yes.
5 Replies
Power 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.
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!
"upstream system" means you have to do that outside of Power BI - before your data is loaded into Power BI.
