Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

HOW to simulate a DIVIDEX

Is there any way to simulate a DIVIDEX (which it's not available) in DAX? For Istance, if I want to simulate a division row by row from 'table1'[column1] and 'table1'[column2], it is possible to u...
Anonymous's avatar
Anonymous
Not applicable
2 years ago

I have to divide across rows (sales invoice line), the data in the column of the total amout and the data in quantity column.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

You didn't share sample data so this is only a guess

 

SUMX(table1,DIVIDE([column1],[column2])