Forum Discussion
Calculating Difference from Previous Row
Hi, we have a table of data and results for each half term for a unique ID. Example table below - what I want to be able to find is the half termly changes in grade value between half terms (excl...
Hi, thank you for your response to this.
As stated before I am fairly new to Power BI - I know how to Group by a column (and then re-expand it) but please could you explain how I would add a shifted Grade Value column? Is this done within the Group By window?
For the Subtraction, I am assuming this is a simple Column A - Column B calculation?
ronrsnfld
Super User
Super UserYou need to do it in the advanced editor of the power query user interface. From Power BI select transform data. In the left hand column, select a new query from blank. From the home tab, select advanced editor. Then paste the code above into the window that opens in place of what is already there. You can then examine the code and the applied steps to better understand the process.