divide in row

[gsulaimon]

i want to divide this by each other to give the % but i have been finding it difficult

i want to divide this by each other to give the % but i have been finding it difficult

[v-yuta-msft]

@gsulaimon ,

Could you please share the sample data and give the expected result?

Regards,

Jimmy Tao

[VijayP]

Can you please rephrase your question. Its not clear

[gsulaimon]

@v-yuta-msft @VijayP 

KPIs       value

ABC        18

ade       18

wade    27

def      27 

I want to divide the row's value by each other 

 i.e wade/def 

       ABC/ade

I need a DAX expression what would help achieve this

[v-yuta-msft · Accepted solution]

@gsulaimon ,

In query editor, create an index from 1, then create a calculate column using dax below:

Result = 
VAR Current_Index = 'Table'[Index]
VAR Current_Value = 'Table'[value]
RETURN
IF(MOD(Current_Index, 2) <> 0,  Current_Value / CALCULATE(MAX('Table'[value]), FILTER('Table', 'Table'[Index] = Current_Index + 1)))

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.