Forum Discussion

chethan's avatar
chethan
Icon for Resolver III rankResolver III
9 years ago

Help on the Power BI DAX

HI,

 

Please help me on preparing below Excel formula to Power Bi DAX

 

& I have not created any Measures & Custome Coloum in Power BI

 

 

=IFERROR(SUM(P8:Q8)/O8,0)

=IFERROR(K8/AVERAGE(H8:I8),0)

=IFERROR(X8/W8,0)

=IFERROR((U8-S8)/U8,0)

=IFERROR(AF8*T8,0)

=IFERROR(AVERAGE(H8:I8),0)

 

 

Thanks in Advance

 

Regards,

Chethan K

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

     Hi chethan

     

    Can you provide the data? Then I'll prepare the DAX-statements for you. If you can't do that, I need atleast column headers.

     

    Thanks in advance.

     

    Best

    Martin

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi chethan

         

        I think what you want is simple enough to provide, but I can't seem to figure out what columns to put into if-statemnts from what you've provided. I'll write a general method for achieving what you want. Then we can work together from there to figure out, what you need.

         

        The DAX-formula goes like this: IFERROR( logical expression ; value if true ; value if false )

         

        So for example =IFERROR(SUM(P8:Q8)/O8,0) would go something like this: IFERROR((SUM(COLUMN1) + SUM(COLUMN2)) /SUM(COLUMN3);0;(SUM(COLUMN1) + SUM(COLUMN2)) /SUM(COLUMN3))

         

        Please be careful with the parenthesis as they will have a significant influence on the calculations.

         

        Let me know how it goes. I'll gladly elaborate as well.

         

        Best,

        Martin