month end dates between date range

[RK9009]

Hi All, 

I am working with two date columns: 
Example,
StudentID                Start Date     End Date
1                                4/25/2021    7/15/2021    
2                                2/5/2021.    5/25/2021

I 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                Start Date     End Date.             New Column 
1                                4/25/2021    7/15/2021           4/30/2021
1                                4/25/2021    7/15/2021           5/31/2021
1                                4/25/2021    7/15/2021           6/30/2021
1                                4/25/2021    7/15/2021           7/15/2021 - this is the end date 
2                                2/5/2021.    5/25/2021            2/28/2021 
2                                2/5/2021.    5/25/2021            3/31/2021 
2                                2/5/2021.    5/25/2021            4/30/2021 
2                                2/5/2021.    5/25/2021            5/25/2021


Any thoughts on how to do this. Thank you so much.

[v-robertq-msft · Accepted solution]

Hi, 

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?

Thanks in advance!

How to Get Your Question Answered Quickly 

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.

[PaulOlding]

Hi @RK9009 

Here's some DAX to create a new table 

New Table = 
VAR _MonthEndBetween = 
FILTER(
	GENERATE(
		'Table',
		CALENDAR('Table'[Start Date], 'Table'[End Date])
		),
	[Date] = EOMONTH([Date], 0)
	)
VAR _EndDate = 
ADDCOLUMNS(
	'Table',
	"Date", 'Table'[End Date]
	)
RETURN
UNION(_MonthEndBetween, _EndDate)