@IF

[Anonymous]

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

[Anonymous]

Thank You , am gonna try it 

[Greg_Deckler]

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

[Fowmy]

@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 ____