IF function not working

[Anonymous]

Hi,

Can someone explain me what's wrong with this formula?

Thanks

[Fowmy · Accepted solution]

@Anonymous 

If you are creating a measure then, this should

Measure  = 
if ( 
    MAX(table[Due Date]) = "null", "9999", MAX(table[Resolution Date]) - MAX(table[Due Date])
)

work.

[Fowmy · Accepted solution]

So you are doing it in Power Query, this should work:

Table.AddColumn(#"Colonnes renommées13", "Major", each if [Priority] = "Major" and [Issue Type] = "Bug"  then 1 else 0)

[Fowmy · Accepted solution]

@Anonymous 

If you are creating a measure then, this should

Measure  = 
if ( 
    MAX(table[Due Date]) = "null", "9999", MAX(table[Resolution Date]) - MAX(table[Due Date])
)

work.

[Anonymous]

Thanks @Fowmy 

what about this one?

= Table.AddColumn(#"Colonnes renommées13", "Major", each if( [Priority] = "Major" and [Issue Type] = "Bug" )then 1 else 0)

[Fowmy · Accepted solution]

@Anonymous 

You can add as a column to your table using DAX:

Major = if ( and([Priority] = "Major" ,  [Issue Type] = "Bug" ) , 1 , 0)

[Fowmy · Accepted solution]

So you are doing it in Power Query, this should work:

Table.AddColumn(#"Colonnes renommées13", "Major", each if [Priority] = "Major" and [Issue Type] = "Bug"  then 1 else 0)

[Anonymous]

Actually I was trying to transform this power query formula to DAX @Fowmy 

[amitchandak]

@Anonymous , if you creating a measure make sure all other are measures .

If you are creating a new column, make sure all these columns are available in same table

[Anonymous]

@amitchandak thanks

actually I'm trying to calculate measure from these columns 'due date' and 'resolution date'

What would be the correct method?