Forum Discussion
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...
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.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!
UsermasterIncoming CallOutgoing Call
If a extension number exsits in the Usermaster and is displayed in the desination column then it would be marked as "Incoming" and if a extension number exsits in the source column then it would be "Outgoing", but if an extension matches in both columns it would be "Internal".
Please let me know if this helps? SivaMani
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.
I receive this error? Thank you for your help thus far. SivaMani