Forum Discussion

JohannB's avatar
JohannB
Helper I
8 years ago

Multip[le sum functions

I am currently trying to convert a excel worksheet to Pwower BI but cannot find a proper solution. The formula used in Excel is '=SUM(((L15*65%)*70%)*10%)+(L15*65%)*70% The one I am usesing in Powe...
Need Help
JohannB's avatar
JohannB
Helper I
8 years ago

Thank you Conor, The data is a table that is imported from SQL. The formula keeps on giving me the following error

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
8 years ago

Hi JohannB,

 

Have you tried the solution provided by ConorHG above? Does it work in your scenario? If it works, could you accept it as solution to close this thread?

 

If you still have any question on this issue, feel free to post here. :smileyhappy:

 

Regards