Forum Discussion
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.
- Anonymous4 years ago
https://docs.microsoft.com/en-us/dax/
you'd better learn DAX function first, and compare it with your excel formular
2 Replies
- amitchandak
Super User
piotrgrendus87 ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. - AnonymousNot applicable
https://docs.microsoft.com/en-us/dax/
you'd better learn DAX function first, and compare it with your excel formular