How can I create a new column by dividing values in one column by another column? I need to account for zero values in the denominator.
Go to Solution.
DIVIDE formula should make it. simply add New Column (Modeling ribbon) and type the formula:
New Column = DIVIDE(Table1[Numerator],Table1[Denominator])