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

Anything related to PowerPivot and DAX Formuale
charingane
Posts: 7
Joined: Mon Apr 23, 2018 10:20 pm

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

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.
Last edited by charingane on Wed Apr 25, 2018 9:14 pm, edited 1 time in total.

MattAllington
Posts: 1068
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

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

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/
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training

charingane
Posts: 7
Joined: Mon Apr 23, 2018 10:20 pm

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

MattAllington
Posts: 1068
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

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

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
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training

charingane
Posts: 7
Joined: Mon Apr 23, 2018 10:20 pm

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

Hello , thanks for interesting
you find in this link file sample1 content data base with pivot table :

and here the file result content the function that we need to solve using DAX :

charingane
Posts: 7
Joined: Mon Apr 23, 2018 10:20 pm