Bring in rows from one table into a new table

[Anonymous]

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

[amitchandak]

@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  columns replace "Quarter Account" with ""

https://radacad.com/pivot-and-unpivot-with-power-bi

[Anonymous]

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

[amitchandak]

@Anonymous , That is power Query.

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]

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

[v-chenwuz-msft]

Hi @Anonymous ,

Of course yes, when you get the result from dax expression @amitchandak  provided. you can use filter() to filter some rows you do not want.

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] <> "20Q3" )

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.