Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

Calculating Change since Last Refresh

Hi everyone - I have a data set that tracks Revenue and Revenue Risk without any date indicator applied. It's rather simple, the table looks like this: Company Name Revenue Revenue Ri...

v-chuncz-msft
6 years ago
Anonymous

You need to save the data before the refresh, then compare the current data with the previous data.

https://community.powerbi.com/t5/Desktop/How-can-I-save-records-before-refreshing-my-data/m-p/367936

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11697333-allow-for-point-in-time-snapshots-for-reports-data

v-chuncz-msft

Community Support

6 years ago

Anonymous

You need to save the data before the refresh, then compare the current data with the previous data.

https://community.powerbi.com/t5/Desktop/How-can-I-save-records-before-refreshing-my-data/m-p/367936
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11697333-allow-for-point-in-time-snapshots-for-reports-data

Forum Discussion

Calculating Change since Last Refresh

Related content

Calculate YoY change

Recommended Deployment Process for Incremental Refresh Changes

Calculated tables are not being refreshed automatically anymore

Last Refresh Date change Timezone

MoM calculation