Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |