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....
Need Help
  • aj1973's avatar
    aj1973
    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.