• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Percentage of row amount over previous row

Aquila

New Member
Hello, I have the following table ,
upload_2018-12-2_23-11-26.png
, my question is to know how I can get by DAX, the percentage of a row with respect to the previous one, which is what is colored in red. The idea is to develop a measure (not a calculated column).
Regards.
 

Attachments

  • upload_2018-12-2_23-11-11.png
    upload_2018-12-2_23-11-11.png
    14.2 KB · Views: 2
  • Percentage of row amount over previous row.xlsb
    9.3 KB · Views: 2
Hi:

May be something like this?

Step 1:
Add index column
upload_2018-12-3_16-4-15.png

Step 2:

Calculate Previous sales as Measure
upload_2018-12-3_16-5-43.png

Step 3:
Calculate Percentage difference as column
upload_2018-12-3_16-6-30.png

Thanks
 
Back
Top