month end dates between date range

Question

Hi All,&nbsp;I am working with two date columns:&nbsp;Example,StudentID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Start Date&nbsp; &nbsp; &nbsp;End Date1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4/25/2021&nbsp; &nbsp; 7/15/2021 &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2/5/2021.&nbsp; &nbsp; 5/25/2021I am trying generate a list of dates that include month end dates or end date. An example of the result that I am looking for,StudentID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Start Date&nbsp; &nbsp; &nbsp;End Date.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;New Column&nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4/25/2021&nbsp; &nbsp; 7/15/2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4/30/20211&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4/25/2021&nbsp; &nbsp; 7/15/2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5/31/20211&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4/25/2021&nbsp; &nbsp; 7/15/2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6/30/20211&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4/25/2021&nbsp; &nbsp; 7/15/2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7/15/2021 - this is the end date&nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2/5/2021.&nbsp; &nbsp; 5/25/2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2/28/2021&nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2/5/2021.&nbsp; &nbsp; 5/25/2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3/31/2021&nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2/5/2021.&nbsp; &nbsp; 5/25/2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4/30/2021&nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2/5/2021.&nbsp; &nbsp; 5/25/2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5/25/2021Any thoughts on how to do this. Thank you so much.

v-robertq-msft · Accepted Answer

Hi,&nbsp;
Have you followed the DAX formula posted by PaulOlding to find the solution to your problem?
If so, would you like to mark his reply as a solution so that others can learn from it too?
&nbsp;
Thanks in advance!
How to Get Your Question Answered Quickly&nbsp;
&nbsp;
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

month end dates between date range

2 Replies

Related content

convert date to month name

Add months to date

Group dates to Month

Month to Month Flow Calculation

Extract month and year from date