Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Create UNION keeping DAX calculated fields (ways to perform this)

Hello,   I just created a report in which I get data from multiple tables with different data structure. I needed to create some calculated fields in each table and after that to perform UNION in o...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, Anonymous 

    First, Each table argument of 'UNION' must have the same number of columns.

    Second, for your requirement, you could add blank columns in SELECTCOLUMNS expression not in table.

    For example:

    SELECTCOLUMNS('Table',"a",[a],"b",[b],"blank c",BLANK())

    Best Regards,
    Lin

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

hi, Anonymous 

First, Each table argument of 'UNION' must have the same number of columns.

Second, for your requirement, you could add blank columns in SELECTCOLUMNS expression not in table.

For example:

SELECTCOLUMNS('Table',"a",[a],"b",[b],"blank c",BLANK())

Best Regards,
Lin

Anonymous's avatar
Anonymous
Not applicable
7 years ago

This is working fine! Many thanks for your help