## Search found 7 matches

Tue Jun 05, 2018 7:43 pm
Forum: PowerPivot/DAX
Topic: PowerBI calculation problem
Replies: 2
Views: 1254

### Re: PowerBI calculation problem

Hello, Thanks for your time https://image.ibb.co/n1JbYT/Sanss_titre.png Using a dax column in power BI I came up with the following code: Grap. Allocation = CALCULATE ( PRODUCTX ( Table2; [1+R] ); FILTER ( ALL ( 'Table2' ); 'Table2'[ index]< EARLIER ( 'Table2'[ index] ) ) ) * CALCULATE ( PRODUCTX ( ...
Tue Jun 05, 2018 3:01 am
Forum: PowerPivot/DAX
Topic: PowerBI calculation problem
Replies: 2
Views: 1254

### PowerBI calculation problem

Hello guys, You might have seen a couple of my post earlier where I was asking how to multiply some column with one another using this formula https://image.ibb.co/cVKSwx/31230404_1815373445213417_5327313628200697856_n.png If you haven’t seen it before here tis the link to that post: http://powerpiv...
Thu May 31, 2018 10:45 pm
Forum: PowerPivot/DAX
Topic: [URGENT] how to multiply different columns with a dax measure
Replies: 1
Views: 1912

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

Hello, 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 properl...
Sat Apr 28, 2018 9:52 am
Forum: PowerPivot/DAX
Topic: how to multiply different columns with a dax measure [Solved]
Replies: 5
Views: 2474

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

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...
Thu Apr 26, 2018 7:38 pm
Forum: PowerPivot/DAX
Topic: how to multiply different columns with a dax measure [Solved]
Replies: 5
Views: 2474

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

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-wI2C7UgjCg9-fcFGOzRtpyNBwH/view?usp=sharing and here the file result content the function that we need to solve using DAX : https://drive.google.com/file/d...
Wed Apr 25, 2018 8:10 pm
Forum: PowerPivot/DAX
Topic: how to multiply different columns with a dax measure [Solved]
Replies: 5
Views: 2474

### 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/ Thanks for you answer, i want to calcul the column using this ...
Mon Apr 23, 2018 11:35 pm
Forum: PowerPivot/DAX
Topic: how to multiply different columns with a dax measure [Solved]
Replies: 5
Views: 2474

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

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 b...