Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Excel formula in Dax

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,MA...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

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