Forum Discussion

PowerBIBeginer's avatar
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....
  • aj1973's avatar
    5 years ago

    Hi PowerBIBeginer 

    Are Table1 and Table2 related? if so 

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