Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How to return either a single text variable or multiple text variable with the IF function in DAX

Hi, Can anyone help me with this, I am trying to return either a single text variable or multiple text variable within an IF function in DAX. This would be based on a variable IsManager = 1 will retu...
Help
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi Anonymous 
Unfortunately, IF function deals only with scalar values and cannot accept tables. I hope one day  DAX will have an IFTABLE function. If you can provide more context perhaps I can support you further.