How to write excel formula in DAX

[newtodax]

How to convert below excel formula to DAX?

=IF(ISERROR(AVERAGEIFS('P'!$U$3:$U$2186,'P'!$H$3:$H$2186,'C'!$I2,'P'!$X$3:$X$2186,'C'!$C2,'P'!$F$3:$F$2186,'C'!$F2)),"No"


=IF(ISERROR(AVERAGEIFS(UP,MAT,MAT,WORLD,PLANNING,LINE,LINE)),"No"

***Table Name=P,C

>>>Dataset in Excel

Table P

UP

MAT

WORLD

LINE

123

ABC

EMEA

AX

456

XYZ

ASA

LM

789

MNP

AME

AR

Table C

MAT

Planning

Line

ABC

ACD

AX

XYZ

KBC

LM

MNP

HKR

AR

 

[GraH - Guido]

Hi, don't assume you need the same formulae in DAX as you would in Excel.
First learn to understand the concept of filter and row context; read some articles by Marco Russo and Alberto Ferrari, Rob Collie, Matt Allington, vids of Mike Girvin,... to get you started.

 

[pecoflyer]

Cross post - Reported