topic month end dates between date range in DAX Commands and Tips

month end dates between date range

RK9009 — Fri, 04 Feb 2022 18:11:14 GMT

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.

Re: month end dates between date range

PaulOlding — Fri, 04 Feb 2022 19:42:21 GMT

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)

Re: month end dates between date range

v-robertq-msft — Wed, 09 Feb 2022 07:24:21 GMT

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.