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,MA...
thank you so much i found the souliotns here,
Greg_Deckler
Community Champion
Community ChampionGeneral 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.)
Thank you Greg.I am very new to DAX.Can you please show me in Formula?