Forum Discussion

smpa01's avatar
smpa01
Community Champion
2 years ago
Solved

Conditional table functions in dax

Is it possible to write table functions that are conditional. Pseudocode if val=1 return table1 else union(table1,table2)   I have a use case where I am querying tables based on a condition a...
Need Help
  • jeffrey_wang's avatar
    jeffrey_wang
    2 years ago

    IF function only returns a scalar value.

parry2k's avatar
parry2k
Super User
2 years ago

smpa01 end of the day you have to union all the tables and then filter, and build that logic in the filter column. I don't see any other way to do this using DAX.