Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Excel Formula conversion to DAX

I have a average calculation base for % perfomance, and can get the number by doing multiple steps within Power BI measure, However hoping someone can point me in the correct direction to express the...
Anonymous's avatar
Anonymous
Not applicable
6 years ago
Please share sample data and expected output.
Thanks
Pravin
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Please see below Data 

     

     

     
     
     

    Formula in Excel is CR=Y1*((1-WA%)*(Prod C/(Prod C+Prod P))+(1-WP%)*(Prod P/(Prod C+Prod P)))/(1-%_F)

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Create new column in power BI as below

       

      CR=table[Y1]*((1-table[WA%])*(table[Prod C]/(table[Prod C]+table[Prod P]))+(1-table[WP%])*(table[Prod P]/(table[Prod C]+table[Prod P])))/(1-table[%_F])

       

      I assume here all values are numeric not of type text.

      and all are column not measure.

       

      Note: replace "Table" with your table name in above formula.

       

      Thanks & regards,
      Pravin Wattamwar
      www.linkedin.com/in/pravin-p-wattamwar

      If I resolve your problem Mark it as a solution and give kudos.