cancel
Showing results for
Did you mean:
Frequent Visitor

## line chart to show year target every month

I would like to create a column or measure that calculate the Year target based on sum of month target and display in a chart as one horizontal line (month as x-axis) filtered by data in another column (facility). The "Year Target" in below table in what I am trying to get. Some of the rows have month target empty.

Facility         Date          Month Target          Year Target
A           Jan-19                    50                            250
A           Feb-19                   50                             250
A           Mar-19                  50                            250
A           Apr-19                   50                             250
A ...........
B            Jan-19                   60                           300
B             Feb-19                  60                            300
B            Mar-19                  60                             300
B            Apr-19                   60                            300
B ..........
C ...............

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team

## Re: line chart to show year target every month

Hi @Xinhui04,

You can try to use following measure formula to calculate the year cumulative based on current year and grouped by Facility.

```Measure =
VAR currdate =
MAX ( Table[Date] )
RETURN
CALCULATE (
SUM ( Table[Month Target] ),
FILTER (
ALLSELECTED ( Table ),
YEAR ( Table[Date] )
= YEAR ( currdate )
),
VALUES ( Table[Facility] )
)
```

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

For learning resources/Release notes, please visit: | |
Community Support Team

## Re: line chart to show year target every month

Hi @Xinhui04,

You can try to use following measure formula to calculate the year cumulative based on current year and grouped by Facility.

```Measure =
VAR currdate =
MAX ( Table[Date] )
RETURN
CALCULATE (
SUM ( Table[Month Target] ),
FILTER (
ALLSELECTED ( Table ),
YEAR ( Table[Date] )
= YEAR ( currdate )
),
VALUES ( Table[Facility] )
)
```

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

For learning resources/Release notes, please visit: | |