Solved: Re: IF NA in Dax Language

ivansitoiv · ‎08-23-2022

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

Samarth_18 · ‎08-23-2022

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

Best Regards,
Samarth

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin

View solution in original post

Samarth_18 · ‎08-23-2022

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

Best Regards,
Samarth

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin

Jihwan_Kim · ‎08-23-2022

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 )

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Go to My LinkedIn Page

ivansitoiv · ‎08-23-2022

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

IF NA in Dax Language

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024