Forum Discussion
How to show evolution between old & new source file ?
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
3 Replies
v-lili6-msftCommunity Support
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
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
