Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Excel formula in DAX

Hi Experts   Looking at the attached screen output how would you do the following calculation in DAX.   i want to be able to work out H5 = H4*G5 and populate that down in a column in my table. ...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous ,

     

    One sample for your reference, please check the following steps as below.

     

    1. Insert an index column in power query.

     

    2. Create a calculated column as below.

    H = 
PRODUCTX(FILTER('Table','Table'[Index] <=EARLIER('Table'[Index])),[1-d/n])

     

v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi Anonymous ,

 

One sample for your reference, please check the following steps as below.

 

1. Insert an index column in power query.

 

2. Create a calculated column as below.

H = 
PRODUCTX(FILTER('Table','Table'[Index] <=EARLIER('Table'[Index])),[1-d/n])