Saving data from DAX with defined frequency

[Anonymous]

Hello expert !

I need your support for the next topic please:

I have a table A including some Audit results for companies A, B, C ... for different Audit type.

This table is generated with DAX, in which datas are updated frequently.

The demand is how to do in order to have: for every update at the end of every month (end of current month +/- 4 days), create a new column to save the old "Result", and put the new "Result" in the same table (with the update date as Column name).

Please check example below:

Thanks for your support.

BR.

[edhans · Accepted solution]

DAX and Power Query are read only. They cannot save data, nor create archives for comparisons. Your historical data needs to be made available by your source product or some other means.