Forum Discussion

PowerBIBeginer's avatar
PowerBIBeginer
Helper V
5 years ago
Solved

simple division formula

Hello All,

I'm in one small confusion, pls guide.

CP = (Table1[WO]) / (Table2[TA])
 
table1 and table2 are table's. I want to devide WO column value from table1 devided by TA column from Table2..
 
how to get this
 
Need Help

2 Replies

  • aj1973's avatar
    aj1973
    Community Champion
    5 years ago

    Hi PowerBIBeginer 

    Are Table1 and Table2 related? if so 

    CP = DVIDE(SUM(Table1[WO]), SUM(Table2[TA]), BLANK())

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi PowerBIBeginer .

    Use CP=DIVIDE(Table1[WO]),Table2[TA])

     

    If this post helps, then please mark it as Accept as Solution.