MTD sale for current year and previous year

[harib]

Hi Friends,

I would like to show  YTD sale for actual data (year 2017) and then YTD (Total days) sales for previous (year 2016). 

ID Date         Sales
1 01.01.2016 10
2 02.01.2016 15
3 03.01.2016 11
4 10.01.2016 8
5 12.01.2016 7
6 01.01.2017 10
7 02.01.2017 12
8 03.01.2017 9

If anyone know please let me know.

Thanks in advance

[amitchandak · Accepted solution]

@harib , In case you are planning to select a date , join with date table and try measures like these. use slicer and date,  month from date table

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))

last year MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-12,MONTH)))
last year MTD (complete) Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH(dateadd('Date'[Date],-12,MONTH))))

you can subract more than 12 month if you want keep dates of 2020

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))

[harib]

@amitchandak 

It's working fine as i expected. Thanks