How to get same period YTD across any previous years in a single formula

[Antmkjr]

How to get the same period YTDs across any previous years in a single formula.

ie.  across a Matrix like this, i want the June YTDs across all years :

[rodrigosan]

Hello @Antmkjr  how are you?
would it be like this?

Did I solve your problem?
Please mark as solution so others can find this solution.
https://www.linkedin.com/in/rodrigosanpbi/

[Antmkjr]

can you share the formula

[rodrigosan · Accepted solution]

I inserted it in the answer below.
It was this:

***************************************************

Month YTD =

VAR vMonth = MONTH(TODAY())

RETURN

CALCULATE(

[Sales Amount (YTD)],

'dCalendar'[Month] = vMonth)
***************************************************

Did I solve your problem?
Please mark as solution so others can find this solution.
https://www.linkedin.com/in/rodrigosanpbi/

[Antmkjr]

Would you mind attaching the pbix as well?

[Antmkjr]

No I only want June YTD for all the years, ie. 2022 june YTD, 2021 June YTD,2020 June YTD etc in a single formula

[rodrigosan]

I didn't understand the application very well.
This result can be obtained from the filter.

Could you contextualize the objective?

Did I solve your problem?
Please mark as solution so others can find this solution.
https://www.linkedin.com/in/rodrigosanpbi/

[Antmkjr]

Yes , but every month it should calculate automatically, so for next month it should calculate YTD August across all years, and then Sept YTD across all years so on.

[rodrigosan]

See if this is it:

***************************************************

Month YTD =

VAR vMonth = MONTH(TODAY())

RETURN

CALCULATE(

[Sales Amount (YTD)],

'📅dCalendar'[Month] = vMonth)
***************************************************

Did I solve your problem?
Please mark as solution so others can find this solution.
https://www.linkedin.com/in/rodrigosanpbi/

[Antmkjr]

Could you pls attach the pbix?

[rodrigosan]

Of course, here's the link: https://easyupload.io/z0udod

This is my test file.
These are fictitious data.

Did I solve your problem?
Please mark as solution so others can find this solution.
https://www.linkedin.com/in/rodrigosanpbi/