Forum Discussion
Add a value to a column depending on a date.
jthomson exactly when i refresh it will show the value as of now and the value as of before the refresh will be eliminated.
I do not have the data against the date of change.
I understand for the origin value this maybe impossible. But do you think it maybe possible lets say going forward if I was to say the value on the first of the next month.
So I can lets say create a column which stores the value as of 01/10/2020 00:00 then when I refresh on 02/10/2020 I would have three columns one showing the value as when we captured yesterday and then the 'real time' value?
You're going to need to work out how you store more than one value for a given value, this is more a question of how you store your data rather than anything within PBI Desktop at this stage. Once you've got a data model in place that can store id-value-date for more than one date, your desired end result should be trivial, but you know your data better than I do, there's many ways to do this but only you'll know what the best way to solve the problem is.