Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

IF function not working

Hi,

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

Thanks

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.

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
5 years ago
Anonymous

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

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

7 Replies

amitchandak
Super User
5 years ago
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
  Not applicable
  5 years ago
  amitchandak thanks
  actually I'm trying to calculate measure from these columns 'due date' and 'resolution date'
  What would be the correct method?
Fowmy
Super User
5 years ago
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
  Not applicable
  5 years ago
  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
    Super User
    5 years ago
    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)

Related content