What is the appropriate to create a new column in the data that has multiple IF statements. Below is what I started but I think I am missing something. I am trying to use nested IF statements. I know how to do it when dealing with less than or equal to but in the case where its equal and there is no false I am new to that and likely over thinking it.

Based on the Academic Year in the Academic Year Column I am trying to sign a specific number, which is the Cost of Instruction.

SOLVED! This is the formula I needed to use. Then after that I figured out that I could have just used a conditional column. I racked my brain for nothing!!!

= Table.AddColumn(#"Reordered Columns2", "Instructional Cost", each if [Academic Year] = "2012-13" then 304 else if [Academic Year] = "2013-14" then 309 else if [Academic Year] = "2014-15" then 313 else if [Academic Year] = "2015-16" then 299 else if [Academic Year] = "2016-17" then 305 else if [Academic Year] = "2017-18" then 300 else 300)

Hi, quick questionâ€¦are you able to combine arguments with text and integers eg:
SWITCH( TRUE(
status = â€śQuoteâ€ť && probability >= 75, â€śHigh probability of winning quoteâ€ť
)

Figured it out! For anyone who is interested:

Current Status =
SWITCH (
TRUE (),
'Table'[SALESSTATUS] = "New" && 'Table'[SALES_STAGE] = "Design", "In Detailed Design",
'Table'[SALESSTATUS] = "New" && 'Table'[SALES_STAGE] = "", "In Design",
'Table'[SALESSTATUS] = "Quote" && 'Table'[PROBABILITY] < 75, "Quote - Possible To Win",
'Table'[SALESSTATUS] = "Quote" && 'Table'[PROBABILITY] >= 75, "Quote - Likely To Win",
'Table'[SALESSTATUS] = "In Progress" && 'Table'[SALES_STAGE] = "Won", "Won - Scheduled",
'Table'[SALESSTATUS] = "In Progress" && 'Table'[SALES_STAGE] = "Design", "Won - To Be Detailed",
'Table'[SALESSTATUS] = "In Progress" && 'Table'[SALES_STAGE] = "Quote", "Won - Waiting On Drawings",
"On Hold"
)

Would anyone happen to know how to do incorporate a â€śdoes not containâ€ť field in a Switch/True statement?

I would like to filter out any dashes (aka â€ś-â€ť) in a product string and this is the only piece I canâ€™t figure out.
How you can you write â€śdoes no contain dashesâ€ť in DAX language?

Similar questionâ€¦ but what if I want to use DAX to filter out the product nomenclature that â€śdoes not start with Râ€ť?

That gets me thinkingâ€¦Is there some type of resource where I can find all of the ways to to filter using advanced filtering that you can do by clicking in the report view of PowerBI, but using DAX expressions only?

To the contributors of this post, thank you for all your inputs for this topic to be solved. To help us learn more about your experience in the forum, please take a moment to answer this short forum survey. We appreciate all your help and suggestions. Thanks!

Please, is 'â€™ Tableâ€™[SALESSTATUS] for example, a table column or a measure? I cant use table column for switch on my power BI and I do not know how I could adapt the next column to measures like this