Forum Discussion
Calculate percentage evolution between two tables
Hey guys,
I'm trying to calcultate the percentage evolution between two tables and can't figure out a DAX formula to make this work ...
Let's just say I have a 2018 table and a 2019 table. Each row represents a month (Jan-Feb-Mar-etc) and I'd like to calculate the % evolution for each month (so each row).
What would be the DAX formula to make this work ?
Thanks,
Nick
Hi NB3 ,
Assuming that you have two tables in Power BI then you could create the calculated column below in Table 2019.
Column = VAR a = LOOKUPVALUE ( '2018'[Value], '2018'[Date].[MonthNo], MONTH ( '2019'[Date] ) ) RETURN IF ( ISBLANK ( '2019'[Value] ), BLANK (), DIVIDE ( '2019'[Value] - a, a ) )Here is my test result.
More details, please refer to my attachement.
If you still need help, feel free to ask.
Best Regards,
Cherry
3 Replies
Hi NB3 ,
If it is convenient, could you share the data sample which could reproduce your scenario and your desired output so that we could help further on it?
Best Regards,
Cherry
HI v-piga-msft
Here is an example of what I want exactly.
The result I want is what's highlighted with the formula being the one on top. I just can't find how to make this work in Power BI ...
Thanks,
Nick
Hi NB3 ,
Assuming that you have two tables in Power BI then you could create the calculated column below in Table 2019.
Column = VAR a = LOOKUPVALUE ( '2018'[Value], '2018'[Date].[MonthNo], MONTH ( '2019'[Date] ) ) RETURN IF ( ISBLANK ( '2019'[Value] ), BLANK (), DIVIDE ( '2019'[Value] - a, a ) )Here is my test result.
More details, please refer to my attachement.
If you still need help, feel free to ask.
Best Regards,
Cherry
