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

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

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

Postby charingane » Thu May 31, 2018 10:45 pm

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

RamanaV
Posts: 14
Joined: Thu Oct 19, 2017 12:57 pm

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

Postby RamanaV » Sat Jun 02, 2018 9:12 am

Hi,

The major difference between Excel and Power Pivot (DAX) is
* In Excel you can refer to a cell (A1, B2, AC2, etc.) and you can refer to a range of cells (E2:E200).
* But in DAX you need to think differently. You can refer to an entire column in the table or the entire table.

You can read Matt Allington's blog article on this topic here: https://exceleratorbi.com.au/power-bi-skills-thinking-data-tables/
Matt Allington explained these concepts with examples.

Hope this information helps.


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 3 guests

cron