Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

If and else linked data sources

Good Day,   I was hoping someone could assist me in a very simple(to you) query with a result return.   Scenario: I have two main columns that will contain a log of information. The one column wo...
Need Help
  • SivaMani's avatar
    SivaMani
    5 years ago

    Anonymous, it helps.

     

    Try the below DAX code in a calculated column.

    Type = SWITCH(TRUE(),'Table'[Source] IN VALUES(UserMaster[User extension]),"Outgoing", 'Table'[Destination] IN VALUES(UserMaster[User extension]),"Incoming")
     
    Note: You have to change the Table names as per your model.
     
  • SivaMani's avatar
    SivaMani
    5 years ago

    Try this, 

    Type = SWITCH(TRUE(),'Table'[Source] IN VALUES(UserMaster[User extension]) && 'Table'[Destination] IN VALUES(UserMaster[User extension]),"Internal",'Table'[Source] IN VALUES(UserMaster[User extension]),"Outgoing", 'Table'[Destination] IN VALUES(UserMaster[User extension]),"Incoming")
     
    I am glad that It worked. Please mark it as Solution. Appreciate your kudos!
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Try a new column like this in DAX

 

new column
var _1 countx(filter(Master, Master[Extension] =Data[Source]),Data[Source])
var _2 countx(filter(Master, Master[Destination] =Data[Source]),Data[Source])
return
Switch( True() ,
not(isblank(_1)), "Outgoing",
not(isblank(_2)), "Incoming"
)

Anonymous's avatar
Anonymous
Not applicable
5 years ago
InOut =
var _1 countx(filter(UserMaster, UserMaster[User Extension] =Data[Source]),Data[Source])
var _2 countx(filter(UserMaster, UserMaster[User extension] =Data[Source]),Data[Source])
return
Switch( True() ,
not(isblank(_1)), "Outgoing",
not(isblank(_2)), "Incoming"
)
 
It doesnt like the code marked in red.