A Aquila New Member Dec 3, 2018 #1 Hello, I have the following table , , 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 14.2 KB · Views: 2 Percentage of row amount over previous row.xlsb 9.3 KB · Views: 2
Hello, I have the following table , , 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.
N Nebu Excel Ninja Dec 3, 2018 #2 Hi: May be something like this? Step 1: Add index column Step 2: Calculate Previous sales as Measure Step 3: Calculate Percentage difference as column Thanks
Hi: May be something like this? Step 1: Add index column Step 2: Calculate Previous sales as Measure Step 3: Calculate Percentage difference as column Thanks