Create a table from info of two tables

[Anonymous]

Hello

I have a state change table with the following info:

And as you can see I have the previous and new state.

The problem is that the intial state is not on the list an is on a different table.

I'm trying to merge that info to this table by changing the table where the intial state is present to match the columns on this one, but without sucess.

What I was trying to do is to add the line with the issueid, End Date, intial state = empty; state =The first state.. I tried Merge but with no luck. Tried addcolumn.. no luck (or doing it wrong). Because actually I need to enter a row...

Any help?

[Phil_Seamark]

Hi @Anonymous,

Sounds like you should be able to complete this in either the Query Editor or DAX.  They will have the same challenge in that if you use APPEND in the query editor or UNION in DAX, you'll need to make sure the rows you are adding have the same number of columns (and matching data types).

In your table with the inital state, how similar is that to the table in the screenshot?

[Anonymous]

At the moment I have this, but working on "matching" all the columns

[Phil_Seamark]

Hi @Anonymous

So are you making progress or do you still need help? 🙂

[Anonymous]

After several cut and edit I manage to make it work.

Thanks for the help @Phil_Seamark