Forum Discussion

RK9009's avatar
RK9009
Frequent Visitor
4 years ago
Solved

month end dates between date range

Hi All,  I am working with two date columns:  Example, StudentID                Start Date     End Date 1                                4/25/2021    7/15/2021     2                           ...
Help me please
  • v-robertq-msft's avatar
    v-robertq-msft
    4 years ago

    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's avatar
PaulOlding
Solution Sage
4 years ago

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)