Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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 |
Solved! Go to 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.
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.
User | Count |
---|---|
98 | |
90 | |
83 | |
70 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |