dcrow5378Resolver I4 years agoSolvedSum Switch Values I have a measure that looks at the Value of the current month and compares it to the previous month and applies a switch function if higher than the previous month. I would like to be able to sum th...Show Moresmpa014 years agodcrow5378 can you try this Measure 2 = SUMX(addcolumns(summarize(qm,QM[FacilityID],QM[Indicator],QM[Report Month]),"mx",[Measure]),[mx])
smpa014 years agodcrow5378 can you try this Measure 2 = SUMX(addcolumns(summarize(qm,QM[FacilityID],QM[Indicator],QM[Report Month]),"mx",[Measure]),[mx])
smpa014 years agodcrow5378 can you try this Measure 2 = SUMX(addcolumns(summarize(qm,QM[FacilityID],QM[Indicator],QM[Report Month]),"mx",[Measure]),[mx])
smpa01Community Champion4 years agodcrow5378 can you try this Measure 2 = SUMX(addcolumns(summarize(qm,QM[FacilityID],QM[Indicator],QM[Report Month]),"mx",[Measure]),[mx])
dcrow5378Resolver I to smpa014 years agosmpa01 That seemed to do the trick! I would not have got that one. Appreciate the quick help here!
Related contentNegative values not be summed correctlyAlternative to SWITCH ()?Switch -ContainsstringOrder switching mid workflowUsing Switch
