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

2 Replies

  • 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