Forum Discussion

RichOB's avatar
RichOB
Icon for Post Partisan rankPost Partisan
1 year ago
Solved

% change column MoM

Hi, I want a column that shows the % change month over month. I have the Incident Count that month, the Previous Incidents Count, and the difference in 3 separate measures. For some reason I'm strugg...
  • RichOB's avatar
    RichOB
    1 year ago

    Hi DataNinja777 thanks for your reply. Your solution gave me the correct percents but the ones that should be a minus were a positive and vice versa. For example, May is showing as 4.52% but it should be -4.52%, and June should be 2.03% not -2.03%. Why would this be please?