Excel Formula

[jbenson]

I am looking for a way to convert the below formula from excel to power bi on per week per row basis.

Is that possible? just wanting to stream line some manual excel work 

=ROUND(IF(C9>40,(((C9-40)*1.5)+40)*D9,D9*C9),2)

[bcdobbs · Accepted solution]

It looks like all the cells are on the same row?

• Do you have a similar table imported in Power BI? If so a calculated column will do that for you. Syntax in this case is virtually identical.

[jbenson]

That worked great! Thanks for your help!