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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Syndicate_Admin
Administrator
Administrator

Subtract months and Day to a date

Good Day, I wanted to consult with which Dax I can subtract months or days to a specific date?

1 ACCEPTED SOLUTION
SpartaBI
Community Champion
Community Champion

@Syndicate_Admin this is a very general question 🙂 There are a lot of function that overlaps.
Usually DATEADD can do most of the stuff but it needs to have a proper date table to use it
I think anyway the best thing is to go read and see the videos of these dax fucntions in dax guide:
https://dax.guide/functions/time-intelligence/

And also go to read the full dax patterns explanation:
https://www.daxpatterns.com/standard-time-related-calculations/


2022-05-19 17_30_22-Re_ Need help on DAX function with measure vs colu... - Microsoft Power BI Commu.png

Showcase Report – Contoso By SpartaBI


SpartaBI_3-1652115470761.png   SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

Full-Logo11.png

View solution in original post

1 REPLY 1
SpartaBI
Community Champion
Community Champion

@Syndicate_Admin this is a very general question 🙂 There are a lot of function that overlaps.
Usually DATEADD can do most of the stuff but it needs to have a proper date table to use it
I think anyway the best thing is to go read and see the videos of these dax fucntions in dax guide:
https://dax.guide/functions/time-intelligence/

And also go to read the full dax patterns explanation:
https://www.daxpatterns.com/standard-time-related-calculations/


2022-05-19 17_30_22-Re_ Need help on DAX function with measure vs colu... - Microsoft Power BI Commu.png

Showcase Report – Contoso By SpartaBI


SpartaBI_3-1652115470761.png   SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

Full-Logo11.png

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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