Bring in rows from one table into a new table

Question

I need help creating a new table based off data from my original.&nbsp; Here is the current state and desired tables.&nbsp; Thanks in advance!

amitchandak · Answer

Anonymous , You have two unpivot last two columns you will get two new columns. ONe of them will have these quarter headers. In This new&nbsp; columns replace "Quarter Account" with ""
&nbsp;
https://radacad.com/pivot-and-unpivot-with-power-bi

anonymous · Answer

How would it work in DAX once I click New Table.&nbsp; The "Quarter Account New" and "Quarter Account Drop" are calculated columns, not in the imported data.

amitchandak · Answer

Anonymous , That is power Query. 
&nbsp;
In DAX
union(
summarize(Table, Table[Account], Table[Quater Account New], "New/Drop", "New") ,
summarize(Table, Table[Account], Table[Quater Account Dropped], "New/Drop", "Dropped")
)

anonymous · Answer

Thank you!! Is there a way to add a filter to restrict certain quarters from coming through?

v-chenwuz-msft · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
Of course yes, when you get the result from dax expression amitchandak&nbsp; provided. you can use filter() to filter some rows you do not want.
&nbsp;
new table =
VAR _union =
    UNION(
        SUMMARIZE(
            Table,
            Table[Account],
            Table[Quater Account New],
            "New/Drop", "New"
        ),
        SUMMARIZE(
            Table,
            Table[Account],
            Table[Quater Account Dropped],
            "New/Drop", "Dropped"
        )
    )
RETURN
    FILTER( _union, [New/Drop] &lt;&gt; "20Q3" )

&nbsp;
Best Regards
Community Support Team _ chenwu zhu
&nbsp;
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Bring in rows from one table into a new table

5 Replies

Related content

Matrix table

Tables combine

Lakehouse Table Generate Create Table

Table Transformation

Filtered table