Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
brentyang
New Member

Date slider not correct: adding value to year column

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). 

 

powerbi_datesnotmatching.JPG

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)? 

powerbi_datesnotmatching2.JPG

 

Thank you for your help,

Brent

2 REPLIES 2
Anonymous
Not applicable

Such transformations should be performed during data load via Power Query.
Pragati11
Super User
Super User

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

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.