How to create a column for Previous Value

Sure, Under transform data >click add column >index column from 1

Hi Anonymous 

There are multiple ways to produce you required output, and one of them is as follows:

Create index dimension table which also has previous row side by side.  

Create a relationship between your index dimension table and your fact table.  

Create a calculated column which produces your required output like below:

I attach an example pbix file.  

Best regards,