topic create new table with the column came from existing table in DAX Commands and Tips

create new table with the column came from existing table

Anonymous — Tue, 11 Aug 2020 03:38:54 GMT

Hi,

I'm looking to do the following. I want to create a new table with 4 columns. the values will be coming from the existing table. the existing table have the following columns id, a1, a_code, a_fail, a_dt, a_qty, b_code, b_fail, b_dt, b_qty. i need to combined the values of a* and b* into one table.

The result should be like this sample:

Note: 001 records are coming from a* data while 002 records is coming from b*

ID	code	fail	dt	qty
001	001	bloated	1/1/2020	1
002	002	restart	5/5/2020	1

Thank you.

Re: create new table with the column came from existing table

AntrikshSharma — Tue, 11 Aug 2020 04:18:29 GMT

Try this:

Table = UNION ( SELECTCOLUMNS ( Products, "Column 1", Products[Color], "Column 2", Products[Brand], "Column 3", Products[Category] ), SELECTCOLUMNS ( Customer, "Column 1", Customer[Gender], "Column 2", Customer[Continent], "Column 3", Customer[Education] ) )

Re: create new table with the column came from existing table

Greg_Deckler — Tue, 11 Aug 2020 04:20:57 GMT

Anonymous - Seems possible, but without sample source data it's hard to tell you what exactly the transformation might be.

Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

Re: create new table with the column came from existing table

Anonymous — Tue, 11 Aug 2020 04:45:44 GMT

Thanks a lot 😀. This is what i'm looking for. By the way, How can i added only those column with values . i will not include all those empty columns.

Re: create new table with the column came from existing table

AntrikshSharma — Tue, 11 Aug 2020 04:52:02 GMT

Anonymous In that case you can try:

Table = FILTER ( UNION ( SELECTCOLUMNS ( Products, "Column 1", Products[Color], "Column 2", Products[Brand], "Column 3", Products[Category] ), SELECTCOLUMNS ( Customer, "Column 1", Customer[Gender], "Column 2", Customer[Continent], "Column 3", Customer[Education] ) ), NOT ( ISBLANK ( [Column 1] ) || ISBLANK ( [Column 2] ) || ISBLANK ( [Column 3] ) ) )

Re: create new table with the column came from existing table

Anonymous — Tue, 11 Aug 2020 05:21:31 GMT

Thank you very much!

Re: create new table with the column came from existing table

AntrikshSharma — Tue, 11 Aug 2020 05:25:41 GMT

You're welcome 🙂