Forum Discussion

dcrow5378's avatar
dcrow5378
Icon for Resolver I rankResolver I
4 years ago
Solved

Sum 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...
  • smpa01's avatar
    smpa01
    4 years ago

    dcrow5378  can you try this

    Measure 2 = SUMX(addcolumns(summarize(qm,QM[FacilityID],QM[Indicator],QM[Report Month]),"mx",[Measure]),[mx])

     

     

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
4 years ago

dcrow5378  can you try this

Measure 2 = SUMX(addcolumns(summarize(qm,QM[FacilityID],QM[Indicator],QM[Report Month]),"mx",[Measure]),[mx])

 

 

  • dcrow5378's avatar
    dcrow5378
    Icon for Resolver I rankResolver I
    4 years ago

    smpa01 That seemed to do the trick!  I would not have got that one.  Appreciate the quick help here!