Cumulative total YTD just for the current month

[Anonymous]

Hi Guys,

i would like to show the cumulative total. Instead of seeing the progress, i would like to represent the cumulative total till the current month just for the current month.

Actual cumulative total:

The result should be like that:

Do you know some DAX solution? 

Thank you for all your support! 

Best regards

[amitchandak]

@Anonymous , what is the formula you are using? Have you tried datesytd with date table

example

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

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.