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

Postby charingane » 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. Image

for the first row.

Image

the middle.

Image

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

Image

But it gave me this error.

Image

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: 999
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

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

Postby MattAllington » 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/
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

Postby charingane » Wed Apr 25, 2018 8:10 pm

MattAllington wrote: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/


Thanks for you answer, i want to calcul the column using this formule

Image

(1+rt) the 1+R one and (1+bt) the 1+B one , keep in mind all these three column are DAX measures

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

Re: how to multiply different columns with a dax measure

Postby MattAllington » 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
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

Postby charingane » Thu Apr 26, 2018 7:38 pm

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

https://drive.google.com/file/d/1lgnd3- ... sp=sharing

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

https://drive.google.com/file/d/1R_zPn5 ... sp=sharing

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

Re: how to multiply different columns with a dax measure

Postby charingane » Sat Apr 28, 2018 9:52 am

Thanks for answering,
The sample 1 file contains all the data-base and the pivot table that I have been working on, it is 100% functional and there is no error in there, in the file result there is a column that I named (this is the result that it should give) if you double click on any cell in that column you’ll get all the cells that are involved in the calculation and hence that function that I have send you before….. my problem is to create a dax measure that would do that calculation for me.


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 6 guests