Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
LearningBI1986
Frequent Visitor

Simple if-then statement DAX

Hi guys,

Can I get help with a quick, if-then statement, with the following criteria?

If flight # = 832, flying on Tues, Wed, Thurs, and Fri (Days 2, 3, 4, 5), then seats = 53.

 

I have this, and am getting an error of "token literal expected:"
if [#"Flight #"]="832" && ([Day of Week]=2 || [Day of Week]=3 || [Day of Week]=4 || [Day of Week]=5) then [Seats]="53" else 0

 

Can't seem to figure out my error.

2 ACCEPTED SOLUTIONS
BA_Pete
Super User
Super User

Hi @LearningBI1986 ,

 

Ok. Based on the error you're getting, it looks like you're trying to do this in Power Query. If so, then it's not DAX you need, it's M, and you appear to have mixed both languages in your statement.

The if..then structure in M looks like this:

if (something and somethingElse) or anotherThing
then doThisThing
else doThisOtherThing

 

So, your example would look something like this:

if [#"Flight #"]="832" and List.Contains({2,3,4,5}, [Day of Week])
then 53
else 0

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




View solution in original post

Hi @LearningBI1986 ,

 

Pete provides m-codes that you can use in the PowerQuery editor to add a custom column.

Add a custom column - Power Query | Microsoft Learn

 

For DAX, please try:

Seats = IF(
    'TableName'[Flight #] = 832 && 'TableName'[Day of Week] IN {2,3,4,5,6},
    53,
    0
)

IF - DAX Guide

 

Best Regards,
Gao

Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

View solution in original post

3 REPLIES 3
BA_Pete
Super User
Super User

Hi @LearningBI1986 ,

 

Ok. Based on the error you're getting, it looks like you're trying to do this in Power Query. If so, then it's not DAX you need, it's M, and you appear to have mixed both languages in your statement.

The if..then structure in M looks like this:

if (something and somethingElse) or anotherThing
then doThisThing
else doThisOtherThing

 

So, your example would look something like this:

if [#"Flight #"]="832" and List.Contains({2,3,4,5}, [Day of Week])
then 53
else 0

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




Thank you! I am fairly new to this, so I understand what you are saying now. Thanks again.

Hi @LearningBI1986 ,

 

Pete provides m-codes that you can use in the PowerQuery editor to add a custom column.

Add a custom column - Power Query | Microsoft Learn

 

For DAX, please try:

Seats = IF(
    'TableName'[Flight #] = 832 && 'TableName'[Day of Week] IN {2,3,4,5,6},
    53,
    0
)

IF - DAX Guide

 

Best Regards,
Gao

Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.