topic new table which selects column from 2 tables. in DAX Commands and Tips

new table which selects column from 2 tables.

Anonymous — Tue, 25 Jan 2022 15:02:55 GMT

Hey Team

I need help in writing a dax code for this scenarios:

table1: startdate1, machineID, index_tool1

jan 1111 123

mar 1122 123

table2: startdate2, diameter, removal, index_tool2

feb 0,12 123

I want to create a NEWcolumn or new table. which has the columns from table1(startdate1,machineID, index_tool1), for each row in table1, I want a new row in my NEWcolumn(which is the startdate2- if the startdate1 < startdate2)

NEWTABLE = startdate1, machineID, startdate2, removal

jan 1111 feb 0,12

Re: new table which selects column from 2 tables.

amitchandak — Tue, 25 Jan 2022 16:28:27 GMT

Anonymous , Try a new table like

filter(generate(table1, Table2),[startdate1] <[startdate2])

make sure column name in two tables are not same

Re: new table which selects column from 2 tables.

Anonymous — Fri, 28 Jan 2022 12:15:09 GMT

Hey, amitchandak Thank you so much for your time in helping me out.

I tried to create a measure using your suggestion.

but i get this error: The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value. the startDate column has values in this format : 21.03.2021

Re: new table which selects column from 2 tables.

v-yanjiang-msft — Thu, 10 Feb 2022 07:00:42 GMT

Hi Anonymous ,

What's the data type of your startdate column? If you want to compare the size, it needs to be in the same format.

Best Regards,
Community Support Team _ kalyj