Forum Discussion
Dax New table from multiple tables
Hello,
I would like to create a new table existing of other table colums. Lets say i have table date with te column date_id en i have table sales with the column quantity. The new table would look like: date_id quantity.
i would like to have this done in dax.
Randi , refer various DAx Joins, which you can use
https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
2 Replies
- amitchandak
Super User
Randi , refer various DAx Joins, which you can use
https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
Hi Randi ,
Not sure what your data is. I created a simple table.
Then create a new table.
Table2 = SUMMARIZE('Table1','Table1'[Date],"Quantity",CALCULATE(SUM(Table1[Quantity])))Table2.
Attach the PBIX file for reference. Hope it helps.
If this doesn't work for you or I misunderstand your needs, please consider sharing more details about it. And it would be great if there was a sample file without any sensitive information here.
It makes it easier to give you a solution.
- Sample (dummy dataset) data as text, use the table tool in the editing bar.
- Expected output from sample data.
- Explanation in words of how to get from 1. to 2.
How to Get Your Question Answered Quickly
Best Regards,
Community Support Team_GaoIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
