Calculating Change since Last Refresh

[Anonymous]

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 Risk
Aerry	$1,000,000	$25,000
Berry	$250,000	$100,000
Cerry	$85,000	$15,000
Derry	$1,000,100	$500,000
Erry	$2,000,000	$100,000
Ferry	$10,000,000	$250,000
Garry	$15,000,000	$5,000,000
Harry	$350,000	$50,000

And the summary in my dashboard looks like this: 

Total Revenue	Total Risk
$29,685,100	$6,040,000

As we add new companies to the data set, revenue and risk might change - once the data refreshes. Is there a way to create a calculated measure to show the difference once the data refreshes? 

For Example: If we add a new company today and the revenue is $1,000,000 = I'd like to add an indicator under total revenue to show that there was an increase of $1,000,000 since the last refresh and vice versa. 

Thanks. 

[v-chuncz-msft · Accepted solution]

@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