Full year excluding the year's and month's selection

[LD1]

Hi, 

I would like some answers about those 3 questions please :

For example, below in blue columns, i have selected year 2022 and month from January to March. 

One formula : Turnover € (sum of all years)

1. What is the best formula for the first blue column depending on the selection (here is 2022 vs 2021) : YTD? or sameperiod last year ? 

2. What is the formula if i want to display the full year excluding the year's selection and also the month's selection :

3. Same question for 2021

Here is a little mock-up:

Thank you in advance, 

[LD1 · Accepted solution]

That's perfect ! Thank you. 

I have an other question in the same way.

What about the formula if i want to create a N-3 Full year ? (2019) 

Obviously it's different than PREVIOUSYEAR, but what is the best solution ?

Need your lights !

Thank you in advance

[v-kkf-msft]

Hi @LD1 ,

Please try the measure.

Full Year 2019 =
CALCULATE ( [Turnover], DATEADD ( PREVIOUSYEAR ( Dates[Date] ), -2, YEAR ) )

Best Regards,
Winniz

[v-kkf-msft]

Hi @LD1 ,

Please try these measures.

YTD 2021 = 
CALCULATE ( [Turnover], SAMEPERIODLASTYEAR ( Dates[Date] ) )

Full Year 2021 = 
CALCULATE ( [Turnover], PREVIOUSYEAR ( Dates[Date] ) )

Full Year 2022 = 
CALCULATE ( [Turnover], ALL ( Dates[Date].[Month] ) )

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@LD1 You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000

Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...