- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

# how to multiply different columns with a dax measure

[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

04-22-2018 02:38 PM - edited 04-22-2018 02:42 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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

04-23-2018 11:26 PM

Hi @Salma_00,

Can you share a complete sample? You can use dummy data.

EARLIER can't have a DAX measure as parameter. You can change it into a calculated column.

Best Regards,

Dale

If this post

**helps**, then please consider

**to help the other members find it more quickly.**

*Accept it as the solution*## Re: how to multiply different columns with a dax measure

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

04-24-2018 04:45 PM

hi,

thank you for your reply

i tried to do a calculated column but since my calculations involve other dax measures, my attempts weren't successful

here is a sample of my data

https://drive.google.com/open?id=1VrK4umDrPXhSRwI8eYh7dnfyreuw6VAU

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

04-25-2018 01:54 AM

Hi @Salma_00,

How did you do it? Your formula is fine in the Power BI. Please check it out here.

Column = CALCULATE ( PRODUCTX ( Tableau1, [1+R] ), FILTER ( ALL ( 'Tableau1' ), 'Tableau1'[Index] > EARLIER ( Tableau1[Index] ) ) ) * CALCULATE ( PRODUCTX ( 'Tableau1', [1+B] ), FILTER ( ALL ( 'Tableau1' ), 'Tableau1'[Index] < EARLIER ( Tableau1[Index] ) ) ) * [allocation]

Best Regards,

Dale

If this post

**helps**, then please consider

**to help the other members find it more quickly.**

*Accept it as the solution*## Re: how to multiply different columns with a dax measure

[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

04-25-2018 02:13 AM - edited 04-25-2018 02:14 AM

hi,

it is because my 1+R and 1+B columns are dax measures and not regular column, i actually ahven't thought of using power bi to see if it will work thank you for your recommendation ... but as you can see it won't give you any result for the first and the last row ..so how can i write on a measure than can include them

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

04-25-2018 02:25 AM

Hi @Salma_00,

Solution 1: Add the "=" operator.

Column = CALCULATE ( PRODUCTX ( Tableau1, [1+R] ), FILTER ( ALL ( 'Tableau1' ), 'Tableau1'[Index] >=EARLIER ( Tableau1[Index] ) ) ) * CALCULATE ( PRODUCTX ( 'Tableau1', [1+B] ), FILTER ( ALL ( 'Tableau1' ), 'Tableau1'[Index] <=EARLIER ( Tableau1[Index] ) ) ) * [allocation]

Solution 2:

Column = VAR temp = CALCULATE ( PRODUCTX ( Tableau1, [1+R] ), FILTER ( ALL ( 'Tableau1' ), 'Tableau1'[Index] > EARLIER ( Tableau1[Index] ) ) ) * CALCULATE ( PRODUCTX ( 'Tableau1', [1+B] ), FILTER ( ALL ( 'Tableau1' ), 'Tableau1'[Index] < EARLIER ( Tableau1[Index] ) ) ) * [allocation] RETURN IF ( ISBLANK ( temp ), 0, temp )

If they are measures, we need the original data to develop a solution or a workaround.

Best Regards,

Dale

If this post

**helps**, then please consider

**to help the other members find it more quickly.**

*Accept it as the solution*## Re: how to multiply different columns with a dax measure

[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

04-25-2018 02:51 AM - edited 04-25-2018 03:17 AM

hi Dale,

Sorry to bother you again !!

but i'm kind of lost here wouldn't be the current column involved in the calculation if we ad '=' to the function

i'm not sure if you understood what i'm trying to do here but just to make stuff a little bit clearer this is what i'm trying to calculate using a dax measure

with at being the allocation column

(1+rt) the 1+R one and (1+bt) the 1+B one

these three columns are already being calculated that's why i can't do a clculated colmun cause they differ form row to row

here is a sample of my inital data with a pivot table... this is what i am currently working on (i use excel 2016 btw)

https://drive.google.com/open?id=13oA-cBC0FwEwZqyhvnZWt902Xw4-Q3OD

thank you so much for your help !!