Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

IF function not working

Hi, Can someone explain me what's wrong with this formula? Thanks  
Need Help
  • Fowmy's avatar
    Fowmy
    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.

  • Fowmy's avatar
    Fowmy
    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)
  • Fowmy's avatar
    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)
amitchandak's avatar
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's avatar
    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?