Forum Discussion

neeraj27's avatar
neeraj27
Frequent Visitor
3 years ago

true/false

Terminal = IF(TB_FLIGHT_FACT_REPORT[AIRLINE_NAME]="Star Air" && "Air Asia", "T2","T1")
 
 
I am getting this error for above code: Cannot convert value 'Air Asia' of type Text to type True/False.
DAX

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    You need to do this, 

     

    Terminal = IF(TB_FLIGHT_FACT_REPORT[AIRLINE_NAME]="Star Air" && TB_FLIGHT_FACT_REPORT[AIRLINE_NAME]="Air Asia", "T2","T1")

     

    Right now, it's evaluating "Star Air" as Boolean Datatype, which is why you are getting the error. 

  • tamerj1's avatar
    tamerj1
    Community Champion
    3 years ago

    Hi neeraj27 

    Terminal =
    IF (
    TB_FLIGHT_FACT_REPORT[AIRLINE_NAME] = "Star Air"
    || TB_FLIGHT_FACT_REPORT[AIRLINE_NAME] = "Air Asia",
    "T2",
    "T1"
    )

  • FreemanZ's avatar
    FreemanZ
    Super User
    3 years ago

    hi neeraj27 

    you may also try like:

    Terminal = IF(TB_FLIGHT_FACT_REPORT[AIRLINE_NAME] IN {"Star Air", "Air Asia"}, "T2","T1")