Page 1 of 1

### how to multiply different columns with a dax measure

Posted: Mon Apr 23, 2018 11:35 pm
Hi,

So basically, what i want to do is multiply 3 columns within themselves the thing is for a row in column 1 it has to be multiplied with the set before the row in question for column 2 and the set of rows after the column in question for column 3, I don’t know if I explained my problem properly but basically this is what I want to do.

for the first row.

the middle.

The last row . For my dax measure I tried with the following command

But it gave me this error.

For the ones that do not speak French it states that the context where I put earlier does not exist

My index column is a dax measure that I wrote to make calculation easy for me.

### Re: how to multiply different columns with a dax measure  [Solved]

Posted: Tue Apr 24, 2018 6:48 am
I don't really understand, but you may find this article I wrote a couple of weeks ago useful - it seems like the principles are similar. You may be able to work it out from there.
https://exceleratorbi.com.au/compound-growth-using-dax/

### Re: how to multiply different columns with a dax measure

Posted: Wed Apr 25, 2018 8:10 pm

### Re: how to multiply different columns with a dax measure

Posted: Thu Apr 26, 2018 12:17 pm
this is very tough - I guess you know that already. I have no idea what that formula does but I know a lot about Power Pivot. I am willing to try to help you if you work with me on the problem. Please do the following.

1. create a sample excel workbook that contains the sample data.
2. load the data input data you have into power pivot.
3. build a regular Excel solution so I can see how it works in Excel.

I will take a look and let you know if I have any questions/follow up tasks.

Matt

### Re: how to multiply different columns with a dax measure

Posted: Thu Apr 26, 2018 7:38 pm
Hello , thanks for interesting
you find in this link file sample1 content data base with pivot table :