Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Pivot data in dax

Hello Everybody,   I've no access to the query editor (so DAX) and I got the following table1   Type Phase1 Phase2 Phase3 Type1 12     Type2   10   Type3   8 14   I w...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    Anonymous instead of selectcolumns use summarize

     

    SUMMARIZE( FILTER ( Table, Table[Phase2] <> BLANK()),"Phases", "Phase2", "Data", SUM ( Table[Phase2)))

     

    do it for every phase.

parry2k's avatar
parry2k
Super User
6 years ago

Anonymous instead of selectcolumns use summarize

 

SUMMARIZE( FILTER ( Table, Table[Phase2] <> BLANK()),"Phases", "Phase2", "Data", SUM ( Table[Phase2)))

 

do it for every phase.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    thanks parry2k 

     

    it works fine !

     

    Table2 = 
UNION(
    SUMMARIZE(Table1;"Phase";"Phase1";"Data";SUM(Table1[Phase1]));
    SUMMARIZE(Table1;"Phase";"Phase2";"Data";SUM(Table1[Phase2]));
    SUMMARIZE(Table1;"Phase";"Phase3";"Data";SUM(Table1[Phase3]))
)