Forum Discussion

Surya1's avatar
Surya1
Helper I
8 years ago
Solved

DAX

Hi All,   Someone please help   I have 2 questions.   Q1.There are 2 tables,Table 1 and Table 2 with a unique column called ID.I want to add a column called status in Table 1 by matching the ID...
  • Anonymous's avatar
    Anonymous
    8 years ago

    Reading over your whole post i'm thinking this should be done in Power Query instead of dax.  Never the less, here is the dax for Q1

     

    Q1:  Create a Custom Column:

    Status = var thisRecord = [ID]
RETURN
CALCULATE(
	COUNTROWS('Table2'),
	ALL('Table2'),
	'Table2'[ID] = thisRecord
) > 0

     

    Q2:  I really really stress this is going to be a bad idea.  The 'Edit Queries' are of Power BI is much better suited to creating tables.  Q1 could also be achieved there as well.

     

    Is there a specific reason you want to do this with Dax? 

Surya1's avatar
Surya1
Helper I
8 years ago

I dont have any problem to try other ways other than DAX.Please suggest the best approach.

How can we create a new table from two existing tables using edit queries?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

In the Edit Queries section, if you right click on any query (a table), there is an option called "Reference".

 

This creates a new table that begins as a reference to that other table.  From here you can remove rows, add new columns and do all of the general import manipulate you like.  When you click close and apply, you will see it as its own table, named however you wished.