• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to write excel formula in DAX

newtodax

New Member
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
 
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.
 
Back
Top