Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

SQRT formula implementation in Power BI

Hi,   I have excel formula (Sales/Profit)^(1/3)-1, I am not sure how to implement the same formula in Power BI.   Any suggestions pls.   Thanks, Thimma
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi Thimma,

     

    Try it like below please.

    =Power(divide([sales], [profit]), 1/3) - 1

    SQRT_formula_implementation_in_Power_BI

     

    Best Regards,

    Dale

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

Hi Thimma,

 

Try it like below please.

=Power(divide([sales], [profit]), 1/3) - 1

SQRT_formula_implementation_in_Power_BI

 

Best Regards,

Dale

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks Dale for your answer it worked superb.

 

Thanks,

Thimma