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.
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?
What would be the best way to share?
It are pretty big tables. The total pbix (including purch and invent) is 130MB
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
Register by September 5 to save $200
Check out what's new in the Power BI Community!
Continue your learning in our online communities.