columns into rows with help of dax

[gopik8000]

Hi Team,

I have requirement like this in Table visual using like AC, Fridge, Fan, TV are calculated new measures and month 1 and month 2 and month 3 are coming new column .

Time	AC	Fridge	Fan	TV
Month 1	2	6	8	9
Month 2	5	5	3	7
Month3	7	6	2	3

i want result has like transpose into with help of Dax i required

Timeframe	Month 1	Month 2	Month3
AC	2	5	7
Fridge	6	5	6
Fan	8	3	2
TV	9	7	3

[Anonymous · Accepted solution]

Hi  @gopik8000 ,

Here are the steps you can follow：

1. Create calculated table.

Flag1 =
UNION(
SELECTCOLUMNS('Table', "Month", 'Table'[Time], "Timeframe", "AC", "Target", 'Table'[AC]),
SELECTCOLUMNS('Table', "Month", 'Table'[Time], "Timeframe", "Fridge", "Target", 'Table'[Fridge]),
SELECTCOLUMNS('Table', "Month", 'Table'[Time], "Timeframe", "Fan", "Target", 'Table'[Fan]),
SELECTCOLUMNS('Table', "Month", 'Table'[Time], "Timeframe", "TV", "Target", 'Table'[TV]))

True =
var _table1=
DISTINCT('Flag1'[Timeframe])
return
SUMMARIZE(
    _table1,[Timeframe],
    "Month 1",SUMX(FILTER(ALL('Flag1'),'Flag1'[Month]="Month 1"&&'Flag1'[Timeframe]=EARLIER('Flag1'[Timeframe])),[Target]),
    "Month 2",SUMX(FILTER(ALL('Flag1'),'Flag1'[Month]="Month 2"&&'Flag1'[Timeframe]=EARLIER('Flag1'[Timeframe])),[Target]),
    "Month 3",SUMX(FILTER(ALL('Flag1'),'Flag1'[Month]="Month 3"&&'Flag1'[Timeframe]=EARLIER('Flag1'[Timeframe])),[Target]))

2. Result:

Best Regards,

Liu Yang

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

[Anonymous · Accepted solution]

Hi  @gopik8000 ,

Here are the steps you can follow：

1. Create calculated table.

Flag1 =
UNION(
SELECTCOLUMNS('Table', "Month", 'Table'[Time], "Timeframe", "AC", "Target", 'Table'[AC]),
SELECTCOLUMNS('Table', "Month", 'Table'[Time], "Timeframe", "Fridge", "Target", 'Table'[Fridge]),
SELECTCOLUMNS('Table', "Month", 'Table'[Time], "Timeframe", "Fan", "Target", 'Table'[Fan]),
SELECTCOLUMNS('Table', "Month", 'Table'[Time], "Timeframe", "TV", "Target", 'Table'[TV]))

True =
var _table1=
DISTINCT('Flag1'[Timeframe])
return
SUMMARIZE(
    _table1,[Timeframe],
    "Month 1",SUMX(FILTER(ALL('Flag1'),'Flag1'[Month]="Month 1"&&'Flag1'[Timeframe]=EARLIER('Flag1'[Timeframe])),[Target]),
    "Month 2",SUMX(FILTER(ALL('Flag1'),'Flag1'[Month]="Month 2"&&'Flag1'[Timeframe]=EARLIER('Flag1'[Timeframe])),[Target]),
    "Month 3",SUMX(FILTER(ALL('Flag1'),'Flag1'[Month]="Month 3"&&'Flag1'[Timeframe]=EARLIER('Flag1'[Timeframe])),[Target]))

2. Result:

Best Regards,

Liu Yang

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

[gopik8000 · Accepted solution]

Thanks alot it's working fine 

[gopik8000]

Ac, Fridge , TV,Fan are Calculated measures can't use other than values field                                                              

Timeframe	Month 1	Month 2	Month3
AC	2	5	7
Fridge	6	5	6
Fan	8	3	2
TV	9	7	3

[some_bih]

Hi @gopik8000 just replace row / columns in table / matrix view.