I would like to find a way to save a snapshot of data and have another data refresh, my way of doing this was to duplicate a table, remove it from the refresh by going into power query, then I would have the old data, then when I refresh all the other data it would stay the same while the rest changed. the problem I had is that the column that I wanted to stay the same was a custom column using DAX and when I refreshed the others that changed to the new data. I will try to explain the tables and data I have:
("-" new column)
Table1: Name - Value 1 - Value 2 - Value 3
Table2: Value 1 to 3 - Count of Values
Tabel2Copy: Value 1 to 3 - Old Count of Values
Value 1 to 3 are all custom columns in power bi that use a DAX formula to give a value then used table 2 and a new column count of values which was also a DAX to get me the count of each of the values then it would put the count in the correct rows to match the value. hopefully, this makes sense and someone can help.
