Forum Discussion
Solved
Return table with condition function
DAX conditional functions such as IF SWITCH RETURNS scalar value. I am converting SSRS reports to Paginated Report and publishing in powerBI Report Server(PBIRS) using PowerBI Dataset. I am passing ...
Many thanks Greg, that did the trick to me. Appriciated your Assistance
rxt If they have the same number of columns you could do this:
Table 2 =
VAR __table1 = 'Table5'
VAR __table2 = 'Table6'
VAR __truefalse = IF(TRUE(),1,2)
VAR __table1a = ADDCOLUMNS(__table1,"truefalse",__truefalse)
VAR __table2a = ADDCOLUMNS(__table2,"truefalse",__truefalse)
VAR __table1b = EXCEPT(__table1a,FILTER(__table1a,[truefalse]=1))
VAR __table2b = EXCEPT(__table2a,FILTER(__table2a,[truefalse]=2))
RETURN
UNION(__table1b, __table2b)