Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

@IF

can anyone help me with this if condition whats wrong in it ?

 

 

 
 

 

3 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    Anonymous 

    The formula you are using is supposed to be used as a new column in the Power BI data model table. you are trying to apply in Power Query. In power query, you need to use all simple cases like

    if ___ then ___ elseif ___ else ____

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank You , am gonna try it 

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      5 years ago

      Anonymous I think you just need to use lower case "t" for your then, so then, not Then. M is picky about casing.