cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Xinhui04 Frequent Visitor
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
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: | |
1 REPLY 1
Community Support Team
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: | |