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.
Hello,
I'm strugling with calculation of last year's bookings. I'm using the function SAMEPERIODLASTYEAR, but for some reason when current day or some future date is selected, it returns value of bookings for whole month (picture attached). When I choose yesterday's date, calculation is correct - it takes only same part of last year's month.
I was trying to put in the formula additional filter that limits my table 'Date - bookings' to today()-1, but without any good results.
Has anybody experienced same issue?
Thank you for any suggestions.
Do you have a dedicated date table? If so, is it marked as such?
Hi, thanks for your reply. Yes it is marked as date table. It is calculated table as noted in my post above.
can you upload some sample data?
it's working like it is supposed to. Everything comes down to context. So when you have a date slicer that stops before the current end of the month, it will give you the total of the previous period of that same time.
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 |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |