Forum Discussion
Calculate difference between values in the same column
Try Earlier function
https://community.powerbi.com/t5/Desktop/Explanation-of-the-EARLIER-formula/td-p/529469
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601Hi Resh,
You could try to use below measure to get difference between each month.
trend = SUM('Table (2)'[Value])-CALCULATE(SUM('Table (2)'[Value]), FILTER(ALLEXCEPT('Table (2)','Table (2)'[Project]),MONTH('Table (2)'[Date])=MONTH(MIN('Table (2)'[Date]))-1))Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Resh,
You could try to use below measure to get difference between each month.
trend = SUM('Table (2)'[Value])-CALCULATE(SUM('Table (2)'[Value]), FILTER(ALLEXCEPT('Table (2)','Table (2)'[Project]),MONTH('Table (2)'[Date])=MONTH(MIN('Table (2)'[Date]))-1))
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.