cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Reply
Khashab
New Member

@IF

‎08-15-2021 01:58 AM

Untitled.jpgcan anyone help me with this if condition whats wrong in it ?

 

 

 
 

 

Message 1 of 4
232 Views
0
3 REPLIES 3
Khashab
New Member

‎08-15-2021 02:58 AM

Thank You , am gonna try it 

Message 3 of 4
180 Views
0
Greg_Deckler
Super User
Super User
In response to Khashab

‎08-15-2021 03:03 AM

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


@ 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!: Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Message 4 of 4
169 Views
0
Fowmy
Super User
Super User

‎08-15-2021 02:22 AM

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

Message 2 of 4
198 Views

Helpful resources

Announcements
Vote for T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Vote for your favorite t-shirt design now through March 28.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

March Events 2023A

March 2023 Events

Find out more about the online and in person events happening in March!

View All