Freeze and duplicate column. Load only the second column

[Chris_23]

Hello everyone,

is there a way to show a delta between a column (t-1) and a column (t0)?

I want to show the invoicing between two weeks. But i only have the whole invoicing amount of a project from beginning.

So i came up with the idea to duplicate the column with invoicing amounts and freeze the first column. One week later I only want to refresh the duplicated column and calculate the delta. Is there any possibilty to do so?

Kind regards

Chris

[v-kelly-msft · Accepted solution]

Hi  @Chris_23 ,

Check the similar thread below:

https://community.powerbi.com/t5/Desktop/Calculating-Change-since-Last-Refresh/td-p/832830

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!