IF NA in Dax Language

[ivansitoiv]

I Have this condition in Excel: =IF(Z6="NA",0,3), How do I Translate this to DAX Language?

[Samarth_18 · Accepted solution]

Hi @ivansitoiv ,

For creating a column you could try:-

column = IF('table'[column_which_represent_z6]="NA",0,3)

and for measure it could be like this

Measure = IF(max('table'[column_which_represent_z6])="NA",0,3)

BR,

Samarth

[Jihwan_Kim]

Hi,

I assume you want to create a calculated column.

Please check the below DAX formula whether it suits your requirement.

Excel CC =
IF ( 'table name'[Z6 column] = "NA", 0, 3 )

[ivansitoiv]

The formula is to create a measure or calculated column? because im receiving this error: DAX comparison do not support comparing values of type integer with values of type text