Dynamic Date in Calculate

[Daviejoe]

Hi,

My measure below gives me the end of total for last year, which is what i need for now as the first iteration of my report will have a static front page.

However, I'm sure I'll get asked to make my calculation dynamic.  How do I make my DATESYTD(ENDOFYEAR(DATEADD('Date'[Date], -1, YEAR )), "31/12" section of my code so it reflects one previous to the year selected in the Date Filter?

Measure =

CALCULATE (

    COUNTROWS ( MyTable ),

       FILTER ( MyTable, MyTable[MyColumn] = "Yes" ),

       DATESYTD(ENDOFYEAR(DATEADD('Date'[Date], -1, YEAR )), "31/12")

)

[stevedep]

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Daviejoe]

Hi @stevedep 

thanks for the link, really useful.  Which part, or parts, of my posting did you feel I could improve?

Thanks

David

[stevedep]

What is the table structure (which columns)?
Which tables used (Date Dimension)?

How are they related?

Sample data,

What is your outcome on the sample data and what did you expect,

Your formula.

Preferably a pbi file with sample data, so we can make it work in the sample file and you will have no issues replicating it in your final solution. 

[Daviejoe]

Ha, you're right.  My post was very light on detail.  Thanks for pointing this out and making it clear.

I'll update the post later with more information.

Thanks again, appreciated.

David

[stevedep]

Thanks, looking forward to help with the updated question.