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,
Really struggling with something that I've been at for the past few days.
I have a measure that distributes values between a start date and end date for each month
I also have a similar query that looks at a different table to get the previous years values
Both measures work and return the correct data, but I have a disconnected date table and really struggling to compare current year v previous year on a clustered chart
The value for Dec 2022 needs to shift one year forward to Dec 2023, so that I can compare.
I would really appreciate any help with this. Link to report attached.
Hi,
This approach would solve the problem but would bloat the table.
Total = sum('Final table'[Total_value_usd])
Total in PY = calculate([total],previousyear(calendar[date]))
Hope this helps.
Thanks, will try this later and feedback
Thank you, taking the time to see if this will work for me
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
146 | |
110 | |
107 | |
86 | |
63 |