Calculate difference between values in the same column

[Resh]

Hi all,  I'm new to Power BI and need help. I am trying to find the difference between two values, where: I have a table, what I want to see is how Project X or Project Y have increased or decreased in value over time. As I want to illustrate the change in a bar graph.  I know I need to create a new column/measure, but not sure how to go about it, using the project name and date as the criteria to work out the difference.

Project Value Date

Project X 200 Jun-19

Project X 200 Jul-19

Project X 300 Aug-19

Project Y 5000 Jun-19

Project Y 5500 Jul-19

Project Y 6000 Aug-19

Thanks!

[amitchandak · Accepted solution]

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/823601

[dax · Accepted solution]

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.

[amitchandak · Accepted solution]

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/823601

[VijayP]

Is this data in single column or split across columns.

IF it is in single column you need to split Column

if different columsn you can create measure and then make the visualisation. Please take the Screenshot of your data and show here to give more clear answer