Fill table in the data model with data from table created in the data view(not present in data model

[PaulMoses]

Hi All

I have 2 tables : one that I have created in Data View, by the option "New table" (and so, it is not in the data model), and another created in Power Query. I would like to populate the second one with data from the first. There is no relationship between the 2 tables. I have searched in the topics in the forum, but none of them helped me.

Could someone tell me how to proceed ?

Thanks in advance.

[Anonymous]

Hi @PaulMoses

You can create DAX calculated table with the values from your origina Power Query table.

Say for ex, you have Table 1 from Query, country , city, sales are the columns.

Now you want to createa  DAX table and populate the DAX table from the values of Table 1 and only for USA country.

So, your DAX table formula should be ( Go to Modelling -> New Table) :

DAX Table = FILTER ( Table1, Table1[Country] = "USA")

This is just an example, you can write complex formulas as well.

Hope this is what you are looking for.

Thanks
Raj

[PaulMoses]

Hi @Anonymous

Thank you a lot for you proposal.

But, in fact, my 2 tables already exist (I already have a DAX table). I would like to copy the data from the DAX table, to a table that I created in the Power Query. Another thing is that I would like to copy all the DAX table, without filtering.

Thank in advance.

[Anonymous]

Hi @PaulMoses

PFB my response.

---

@PaulMoses wrote:

Hi @Anonymous

Thank you a lot for you proposal.

But, in fact, my 2 tables already exist (I already have a DAX table). I would like to copy the data from the DAX table, to a table that I created in the Power Query. *** This is not possible, whatever you created in DAX wont appear in the power Query, DAX remains in the model.***

Another thing is that I would like to copy all the DAX table, without filtering. *** This you can do. You can join them, UNION them as you want ***

Thank in advance.

---

 Thanks

Raj

[PaulMoses]

Hi @Anonymous

Thank again for your response.

But, even if tables that were created in DAX can not be seen in Power Query, I would like to know if it can be possible to use DAX for adressing this issue. I mean this : does DAX have access to tables in the data model ? If yes, is there any possibility to copy data to a table in the data model with DAX formulas ?

Thank a lot for helping.

[Anonymous · Accepted solution]

Yes, DAX ahs access to both kind of tables. You can use DAX to join them or UNION them as you want.

Thanks

Raj

[PaulMoses]

Hello @Anonymous

Thank you very much for your help.