Forum Discussion

piotrgrendus87's avatar
4 years ago
Solved

Converting Excel formulas to PowerBi Dax

Hello,
I am using different formulas in an Excel document to calculate measures, I would like to use the same formulas in PowerBI ( Dax ), could I ask for help on how to convert the following formulas:
- =B3+ROUND($B$3*0,1;0)

- =ROUND(C4+($H$6-$C$4)/4;0)

- =ROUND(AVERAGE(E11;E16;E24;E29;E33);0)

- ="+"&E6-C4

- =ROUND(D10+(D10-C10)*(D$2-C$2)/365;0)

- =ROUND(E10+(E10-C10)*$D$12;0)

- =(E11-E$6)/E$6

- =ROUND(E23+((E23-C23)*0,8);0)

- =ROUND(E23/D24;0)

- =ROUND(F23/$D$24;0)

- =C28*(1+D29)

- =ROUND(E28+(E28-C28);0)

- ="+"&ROUND((D28-C28)*100/C28;1)&"%"

- =ROUND((D32-C32)*100/C32;1)&"%"

 

Thank You Very Much for a help.
Regards Piotr.