Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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,
Thanks.
What would be the best way to share?
It are pretty big tables. The total pbix (including purch and invent) is 130MB
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |