Want to Calculate StartDate & EndDate for Non Standard Calendar.

[Rohit_Curate109]

I want to Calculate End date where I have two columns , one is Date Column and Second id Month Year Column. 
I want to Extract EndDate from the Date Column when My Month year changes to another month.
I want my start date as next date from the another month's start date from date column.

I need End Date 28 January 2023 and start date is 29 january.
please help regarding this.

[FreemanZ]

hi @Rohit_Curate109 ,

not if i fully get you, try to plot a visual with your dates[mmm yyyy] column and two measures like:

StartDate = 
MINX(
    FILTER(
        dates,
        dates[mmm yyyy] = MAX(dates[mmm yyyy])
    ),
    dates[date]
)

EndDate = 
MAXX(
    FILTER(
        dates,
        dates[mmm yyyy] = MAX(dates[mmm yyyy])
    ),
    dates[date]
)

or

could you provide how your calendar table is defined (the DAX code?) and what do you expect of that?

[Rohit_Curate109]

Hi, Thank you for the Reply.
The solution You have provided is working good at some extent, but If I talk about my calendar.
It is from 3 jan 2021 to 28 december 2024, and the Dax you have provided is coming right but for Dec-24 month.
I need Start Date of every month and same goes for End Date.
Because I want to calculate MTD, YTD, QTD for Non Standard Calendar which has Max Date for Future Month which is Dec-24.