How to show evolution between old & new source file ?

[florent-3628]

Hi, 

I search someting that maybe not exist:

i have a huge sourcefile and made a report with a lot of measure like "region A = 34%" 

Users of the report ask me to show the evolution between 2 update.

Like if on monday region A is at 34% ; and on tuesday 36% : show "+2%"

Is there a way to do this ? do i have to import the sourcefile twice ?

NB: I don't want to manually export the report data everyday

[florent-3628]

No it's not in the dataset , that's the point.

I update the dataset everyday and i need to get the difference between the day before.

Is it possible with some formula to create a temporary table ? 

Because if i need to just copy manually all the dataset everyday and create again all the measure and columns to do this comparison , it's not gonna work , i'm already near the limit of memory usage.

[v-lili6-msft]

hi, @florent-3628 

If it's not in the dataset, I'm afraid it couldn't be achieved in power bi for now.

you could only keep all the data in the dataset so that they could be compared.

Best Regards,

Lin

[v-lili6-msft]

hi, @florent-3628 

If all the data are in the dataset, you could create a measure to show them

You could refer the quick measure in power bi

https://powerbi.microsoft.com/fr-fr/blog/quick-measures-preview/

https://radacad.com/quick-measures-in-power-bi-you-dont-have-to-write-dax

Best Regards,

Lin