October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more
can anyone help me with this if condition whats wrong in it ?
Thank You , am gonna try it
@Anonymous I think you just need to use lower case "t" for your then, so then, not Then. M is picky about casing.
@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 ____
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
User | Count |
---|---|
30 | |
16 | |
13 | |
12 | |
10 |
User | Count |
---|---|
57 | |
19 | |
11 | |
11 | |
9 |