Help on the Power BI DAX

[chethan]

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

[Anonymous]

 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

[chethan]

HI @Anonymous

Please find the attached Sample Data https://drive.google.com/file/d/0B519oTylwEZ0YzM3Rm05Uk9IUzQ/view?usp=sharing

Regards

Chethan

[Anonymous]

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]

@chethan

Did you try out my suggestion?