Forum Discussion
difference in grafic line
- 4 months ago
I am not sure what you require, MoM calculation for each Cloased and Open status or the difference for two status.
For the first scenario:
Step 1) Create the MoM measures
Closed MoM = VAR _CurrentClosed = CALCULATE ( SUM ( Table1[Number] ), Table1[Status] = "closed" ) VAR _PreviousClosed = CALCULATE ( SUM ( Table1[Number] ), Table1[Status] = "closed", DATEADD ( 'Date'[Date], -1, MONTH ) ) RETURN DIVIDE ( _CurrentClosed - _PreviousClosed, _PreviousClosed ) Open MoM = VAR _CurrentOpen = CALCULATE ( SUM ( Table1[Number] ), Table1[Status] = "open" ) VAR _PreviousOpen = CALCULATE ( SUM ( Table1[Number] ), Table1[Status] = "open", DATEADD ( 'Date'[Date], -1, MONTH ) ) RETURN DIVIDE ( _CurrentOpen - _PreviousOpen, _PreviousOpen )Step 2) Configure the line chart
Configure the line chart with Month on the X axis, both measures on the Y axis, and format both as percentage. This gives you two separate lines showing the month-over-month growth rate for closed tickets and open tickets independently.
Second scenario:
Step 1) Create the difference measure
Closed vs Open Difference = VAR _Closed = CALCULATE ( SUM ( Table1[Number] ), Table1[Status] = "closed" ) VAR _Open = CALCULATE ( SUM ( Table1[Number] ), Table1[Status] = "open" ) RETURN _Closed - _OpenStep 2) Configure the line chart
- X axis: Month (sort it by a month number column so it shows January, February, March in correct order rather than alphabetically)
- Y axis: Closed vs Open Difference
Hi Giada90
Create measure that calculates difference between Closed and Open for each month and use it in a line chart.
Difference =
CALCULATE(SUM('Table'[number]), 'Table'[status] = "closed") - CALCULATE(SUM('Table'[number]), 'Table'[status] = "open") then place year-month colum on X-axis and use Difference into value
If this was not your requirement then you can provide the sample output you are looking for