Excel formula in Dax

[Anonymous]

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

[v-lili6-msft]

HI, @Anonymous

It is calculate the average with multiple conditions, it needs specific data for formula.

Could you please share some data sample and expected output.  Do mask sensitive data before uploading.

Best Regards,

Lin

[Anonymous · Accepted solution]

thank you so much i found the souliotns here,

https://community.powerbi.com/t5/Desktop/Convert-excel-IF-ISERROR-AVERAGEIFS-to-DAX/m-p/586672/highl...

[Greg_Deckler]

General replacement for the xIF functions in Excel are to use CALCULATE with the appropriate filter, or use the equivalent xX function in DAX (SUMX, AVERAGEX, etc.)

[Anonymous]

Thank you Greg.I am very new to DAX.Can you please show me in Formula?