can anyone help me with this if condition whats wrong in it ?
Thank You , am gonna try it
@Khashab I think you just need to use lower case "t" for your then, so then, not Then. M is picky about casing.
@Khashab 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 likeif ___ then ___ elseif ___ else ____
⭕ Subscribe and learn Power BI from these videos ⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Check out the changes to the Power BI Community announced at Build.
Find out more about the May 2023 update.
Visit our Data Stories Gallery and give kudos to your favorite Data Stories.