Forum Discussion

PaulMac's avatar
PaulMac
Helper IV
7 years ago

Having Issues With a Simple Calculation

Hello all   I am trying to replicate an excel formula in Power BI but I can't seem to do it.   I am trying to calculate the Total Calls per 1000 files uploaded.   In Excel column B contains Num...
Need Help
PaulMac's avatar
PaulMac
Helper IV
7 years ago

Hi _donev

 

No, my data looks like the picture below:

 

 

Any thoughts?

 

Kind regards

Paul

 

BobBI's avatar
BobBI
Resolver III
7 years ago

try  DIVIDE function instead of calculate.

 

Calls per 1000 = Divide([offered],[uploaded])*1000

 

Offered and Uploaded are the 2 measure and Calls per 1000 should also be a measure.

Thanks,

SS