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'm having problems getting the date slider (e.g. selected 2019 fiscal year) to match with the date matrix (retrieves the Apr 2018-Mar 2019 year).
I've been trying to use the dateadd formula to change the date column, but it might be easier to shift the FYYYY column. Is there a way I can add a year to the FYYYY column (e.g. from 2017 to 2018 by adding one year interval to all rows in the column)?
Thank you for your help,
Brent
Hi @brentyang ,
Try using DATEADD dax function:
https://docs.microsoft.com/en-us/dax/dateadd-function-dax
If the post is helpful give Kudos or mark it as a solution if it resolves the issue! 🙂
Thanks,
Pragati
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 | |
27 | |
20 | |
15 | |
12 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |