Forum Discussion
Solved
Excel Formula
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)
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.
