Is it possible to write table functions that are conditional.
if val=1 return table1 else union(table1,table2)
I have a use case where I am querying tables based on a condition and I need the code return correct table tied to the condition.
PFA the sample pbix
Solved! Go to Solution.
@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.
@smpa01 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
Thanks 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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.