Forum Discussion
Helper IIICalculate percentage evolution between two tables
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
Resident RockstarHi 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
Helper IIIHI 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
- v-piga-msft
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