Forum Discussion
smpa01
Community Champion
Community ChampionConditional 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...
IF function only returns a scalar value.
parry2k
Super User
Super Usersmpa01 there is a trick to it and here it is :
Table =
var val = 1
VAR table1 = ADDCOLUMNS ( t1, "@Filter", val )
VAR table2 = ADDCOLUMNS ( t2, "@Filter", IF ( val = 1, 0, val ) )
RETURN FILTER ( UNION ( table1, table2 ), [@Filter] = val )
when val = 1
when val is not 1
smpa01Community Champion
Community ChampionThanks for this but I was hoping for something like this somehow in DAX. The condition checking is rather large and susequent action is also rather complex.