cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Satch Member
Member

Problems with YTD & LY YTD

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.

 

 

2 REPLIES 2
Moderator v-sihou-msft
Moderator

Re: Problems with YTD & LY YTD

@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 Member
Member

Re: Problems with YTD & LY YTD

@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

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 168 members 1,980 guests
Please welcome our newest community members: