Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Preparing for a certification exam? Ask exam experts all your questions on May 15th. Register now.
Good Day, I wanted to consult with which Dax I can subtract months or days to a specific date?
Solved! Go to Solution.
@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/
@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/
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
73 | |
70 | |
69 | |
45 | |
41 |
User | Count |
---|---|
49 | |
46 | |
28 | |
28 | |
28 |