- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

DateAdd Number of Intervals not showing for all rows
Hi, I'm trying to spread total hours of a task over a certain number of months. I don't have an end date , but I do have a start date. I thought simple way was to use DateADD , yet my outcome is not configuring for all rows.
Duration Interval = DATEADD('STEP Resource Planning'[Start],[Duration(months)],MONTH)
I want to use this as my End Date column. Wanting to know if this makes sense to do it this way, and if so, how do I have it calculate for all rows.
Thanks.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Assuming you are using a calcuated column:
Duration Interval = DATE(YEAR('STEP Resource Planning'[Start]), MONTH('STEP Resource Planning'[Start]) + 'STEP Resource Planning'[Duration(month)]), DAY('STEP Resource Planning'[Start]))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Assuming you are using a calcuated column:
Duration Interval = DATE(YEAR('STEP Resource Planning'[Start]), MONTH('STEP Resource Planning'[Start]) + 'STEP Resource Planning'[Duration(month)]), DAY('STEP Resource Planning'[Start]))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@JW_van_Holst , oh my goodness, your Dax worked and look all the hours are in the months columns.. so thankful do you know how many hours I've been trying to get this to work? 👼

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
12-05-2024 06:24 AM | |||
09-09-2024 12:31 PM | |||
08-13-2024 08:03 AM | |||
08-14-2024 09:15 AM | |||
06-10-2024 12:05 AM |
User | Count |
---|---|
28 | |
27 | |
25 | |
14 | |
10 |
User | Count |
---|---|
24 | |
21 | |
17 | |
16 | |
10 |