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
amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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.