Forum Discussion
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...
Anonymous instead of selectcolumns use summarize
SUMMARIZE( FILTER ( Table, Table[Phase2] <> BLANK()),"Phases", "Phase2", "Data", SUM ( Table[Phase2)))do it for every phase.
parry2k
Super User
Super UserAnonymous instead of selectcolumns use summarize
SUMMARIZE( FILTER ( Table, Table[Phase2] <> BLANK()),"Phases", "Phase2", "Data", SUM ( Table[Phase2)))
do it for every phase.