How can I get the YTD but adding only last day of the previous year

[juanahumada]

Hi Guys,

I am working in a report based in periods where the fisrt period goes from 31-12-2017 to  27-01- 2018, but when I want to get the YTD sales with the formula TOTALYTD the 31-12-2017 is out of the result.

How can I calculate the YTD including the last day of the year 2017 and not including the last 2 days of Dicember of 2018.

Thank you!!

Juan Ignacio  

[v-yuta-msft · Accepted solution]

Hi juanahumada,

You can use DAX like this pattern instead.

YTD =
CALCULATE (
    aggregation,
    FILTER ( table, table[date] > date1 && table[date] < date2 )
)

Regards,

Jimmy Tao

[juanahumada]

thank you!!!