new query from table

[mauroanelli]

hi all,

i create a new table with with some dax function, now i need to get it to query editor to modify data and merge it qith other queries.

how can i do it?

[Vvelarde]

@mauroanelli

Hi, The Table created with DAX can't be used in Query Editor.

Regards

Victor

[mauroanelli]

if i append all the queries i need and the create a new table with this new append query, then can i appen this table with the other i have created with dax?

[Vvelarde]

@mauroanelli

Depends on your scenario ** But In DAX You can use UNION

[mauroanelli]

union works only if the column are the same

[Vvelarde]

@mauroanelli

Yes, but you can Select the Columns of Table 2 and Name equal to Table 1with the SelectColumns that you want to append.

MYNEWTABLE =
UNION (
    MYTABLE1;
    SELECTCOLUMNS (
        TABLE2;
        "NAME OF COL1 IN TABLE 1"; TABLE2[COLUMN1];
        "NAME OF COL2 TABLE 1"; TABLE2[COLUMN2]
    )
)

Victor

[mauroanelli]

let me explain better.

i have a table made by dax with 5 column and a query with 10 column. 5 of this column have the same title. if it was 2 queries i will append them and get all the same 5 plus the other 5 but with rows = blank.

now i need to do the same but with the table.

if only we could make a query from a table all of this would be simple

[Vvelarde · Accepted solution]

@mauroanelli

Let try to explain a method with a image.

Union and Select Columns

Regards 

Victor