cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

PBI Community Highlights

PBI Community Highlights

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

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 271 members 3,032 guests
Please welcome our newest community members: