Forum Discussion

rxt's avatar
rxt
Icon for Helper I rankHelper I
5 years ago
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 ...
  • rxt's avatar
    rxt
    5 years ago

    Many thanks Greg, that did the trick to me. Appriciated your Assistance

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

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)
rxt's avatar
rxt
Icon for Helper I rankHelper I
5 years ago

Many thanks Greg, that did the trick to me. Appriciated your Assistance

  • CElzinga's avatar
    CElzinga
    Regular Visitor
    3 years ago

    You appear to have marked your response to the answer as the accepted answer. I don't know if it's too late, but you should mark his answer as the solution so that he gets credit for it.