Forum Discussion
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 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.
Anonymous
You need to save the data before the refresh, then compare the current data with the previous data.
1 Reply
Anonymous
You need to save the data before the refresh, then compare the current data with the previous data.