How to use Summarise or SummariseColumns ?

[united2win]

Hi, 

I have the following table with Dax calculated colums:

Unique ID	Price	Y1	Y2	Y3
1	300€	03/02/2020	02/02/2022	02/02/2023
2	300€	03/03/2020	02/03/2022	02/03/2023
3	300€	03/04/2020	02/04/2022	02/04/2023

Basically, I want it summarized (grouped by)  like below:

Unique ID	Price	"Renewal Date"	"Renewal Period"
1	300	03/02/2020	Y1
1	300	02/02/2022	Y2
1	300	02/02/2023	Y3
2	300	03/03/2020	Y1
2	300	02/03/2021	Y2

...

Any help will be greatly appreciated

[v-yalanwu-msft · Accepted solution]

Hi, @united2win 

You could create a new table by the following formula:

newtable =
VAR _a =
    SUMMARIZE ( 'Table', [Unique ID], [Price], [Y1], "Renewal Period", "Y1" )
VAR _b =
    SUMMARIZE ( 'Table', [Unique ID], [Price], [Y2], "Renewal Period", "Y2" )
VAR _c =
    SUMMARIZE ( 'Table', [Unique ID], [Price], [Y3], "Renewal Period", "Y3" )
RETURN
    UNION ( _a, _b, _c )

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.  

[HotChilli]

Assuming there are more rows in the desired table.

In Power Query, select the first two columns, right-click , choose 'Unpivot other columns'

[united2win]

Hi, 

The columns are calculated DAX columns, so they don't appear in power query.