Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
57 | |
21 | |
19 | |
17 | |
16 |
User | Count |
---|---|
85 | |
80 | |
52 | |
37 | |
22 |