Forum Discussion
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,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 |
thank you so much i found the souliotns here,
4 Replies
- Greg_Deckler
Community Champion
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.)
v-lili6-msftCommunity Support
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
thank you so much i found the souliotns here,
