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)...
Need Help
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

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        chethan

         

        Did you try out my suggestion?