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!
Need help with the following scenario:
I need to calculate the count of Last Year YTD Sales:
LY YTD Sales = TOTALYTD([YTD Sales],SAMEPERIODLASTYEAR('BASE BBI AS400'[Fecha Activación].[Date]))
Apparently it is showing the amount of all sales in 2016 and not the value YTD I am looking for, it shows all 2016 sales.
I used the following formula to calculate YTD sales:
YTD Sales = TOTALYTD(COUNTAX('BASE BBI AS400','BASE BBI AS400'[Anexo]),'BASE BBI AS400'[Fecha Activación].[Date])
This formula shows the exact amount for sales starting 01/Jan/2017.
How can I fix the formula to show the total last year from same period on this year?
Solved! Go to Solution.
Have a bit of a read through this article.
https://www.kasperonbi.com/get-the-ytd-of-same-period-last-year-using-dax/
and see if that helps any,
Have a bit of a read through this article.
https://www.kasperonbi.com/get-the-ytd-of-same-period-last-year-using-dax/
and see if that helps any,
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 |
---|---|
115 | |
99 | |
88 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |