@IF

Anonymous · ‎08-15-2021

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

Anonymous · ‎08-15-2021

Thank You , am gonna try it

Greg_Deckler · ‎08-15-2021

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

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Fowmy · ‎08-15-2021

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

Did I answer your question? Mark my post as a solution! and hit thumbs up

⭕ Subscribe and learn Power BI from these videos

⚪ Website ⚪ LinkedIn ⚪ PBI User Group