Forum Discussion

HamidBee's avatar
HamidBee
Icon for Power Participant rankPower Participant
4 years ago
Solved

Problem Creating a table using columns from different tables (DAX)

I am using the following code to join 4 columns from two different tables:   CALCULATETABLE(     SELECTCOLUMNS('2020',"values",'2020'[Value],"Dates",'2020'[Dates]),       SELECTCOLUMNS('2021',"va...
Need Help
Show and Tell
Tips and Tricks
  • v-janeyg-msft's avatar
    v-janeyg-msft
    4 years ago

    Hi, HamidBee 

     

    Calculatetable is not used to connect tables, so the latter code has no effect.

    CALCULATETABLE function (DAX) - DAX | Microsoft Docs

    Calculatetable and Union function both will create a new table.

    Like this:

    Table =
UNION (
    SELECTCOLUMNS ( '2020', "values", '2020'[Value], "Dates", '2020'[Dates] ),
    SELECTCOLUMNS ( '2021', "values", '2021'[Value], "Dates", '2021'[Dates] )
)

    This table can be displayed in the desktop as a new table, or as a variable table in the measure.

    If you don't want to add the third table, you can easily append them in PowerQuery.

    Like this:

     

    Below is my sample.

    Did I answer your question ? Please mark my reply as solution. Thank you very much.
     If not, please feel free to ask me.
     
    Best Regards,
    Community Support Team _ Janey
AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

CALCULATETABLE expects a table for the first argument and filters for any additional arguments, so the 2021 columns are being used as filters on the 2020 columns (which doesn't change anything if these tables are unrelated). This is valid DAX even if it isn't doing what you expect it to.

 

From the names of the columns you've assigned, I would have assumed you wanted to union these (like bcdobbs assumed) but, apparently, you want something else. What is the result you're expecting instead?