Problems with YTD & LY YTD

[Satch]

Hi,

I keep having problems to get the salesamount of LYTD

_YTD = TOTALYTD(SUM(Salesline[_Turnover]);Salesline[CONFIRMEDDLV])

_YTDLY = CALCULATE([_YTD]; SAMEPERIODLASTYEAR('Date'[Date]))

Initial this seems to be working.

But when I filter on a brand it gives salesamount for last year, but there were no sales for that brandtill september 2016.

Have to say that all saleslines are sliced on 1 specific status out of 6 statusses.

[v-sihou-msft]

@Satch

I assume Salesline[CONFIRMEDDLV] is date column and you have built the relationship between Salesline[CONFIRMEDDLV] and 'Date'[Date]. Your expression looks correct. Can you share your sample data?

Regards,

[Satch]

@v-sihou-msft

Thanks.

What would be the best way to share?

It are pretty big tables. The total pbix (including purch and invent) is 130MB