How to make YTD amount display 2021 Jan till Dec ?

[admin11]

Hi All

Below expression working fine :-

Target YTD =

var _max = today()

return

calculate(TOTALYTD(('TARGET_'[TARGET_]),'Date'[Date]),filter('Date','Date'[Date]<=_max))

Can some one share with me how to modify the expression , so that Table 2 can display 2021 whole year target amount , when i click on year=2021 month=12. 

[amitchandak]

@admin11 , try a formula like

This year Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(ENDOFYEAR('Date'[Date]),"12/31"))
Last year Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(ENDOFYEAR(dateadd('Date'[Date],-1,Year)),"12/31"))

[admin11]

Hi All

Below is my PBI sample file :-

https://www.dropbox.com/s/y241pe1l3lho6ip/PBT_V2021_138%20how%20to%20display%20target%20trend%20in%2...

Paul

[V-lianl-msft · Accepted solution]

Hi @admin11 ,

Unfortunately, I can't access the link you shared.

If the problem persists,could you share the sample pbix again?

If you publish duplicate threads, please delete useless threads.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[admin11]

Hi Lianl

Thank you for looking into my post , i have already solve the issue.

Paul