YTD for Average

[Jouni900]

Hi,

I have a target on a monthly level for which I would want to calculate YTD. My source data is on a daily level so in order to get correct monthly target, I have taken AVERAGE from the target value. The problem however comes when I would like to get YTD, let's say on a two month period in the example below, 110.

I have calculated the target which works for an individual month using the formula below

Category FCST = CALCULATE(AVERAGE('SKU Daily Data 2021-2022 - ÄLÄ'[Category FCST]))

How I would be able to extend the YTD for multiple periods?    

Month	Date	Target
1	123	50
1	1234	50
1	12345	50
2	234	60
2	2345	60
2	2346	60

[Jouni900]

@v-jingzhang  Thank you, it worked like a charm!

[v-jingzhang · Accepted solution]

Hi @Jouni900 

If I understand it correctly, you can try the following measure for the monthly YTD. It sumx your [Category FCST] measure. 

YTD =
SUMX (
    FILTER (
        ALL ( 'SKU Daily Data 2021-2022 - ÄLÄ'[Month] ),
        'SKU Daily Data 2021-2022 - ÄLÄ'[Month]
            <= MAX ( 'SKU Daily Data 2021-2022 - ÄLÄ'[Month] )
    ),
    [Category FCST]
)

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.