cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
florent-3628 Frequent Visitor
Frequent Visitor

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 3
Community Support Team
Community Support Team

Re: How to show evolution between old & new source file ?

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
florent-3628 Frequent Visitor
Frequent Visitor

Re: How to show evolution between old & new source file ?

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.

Community Support Team
Community Support Team

Re: How to show evolution between old & new source file ?

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors