How to get Next available date in calculate column

[AmitSaini]

Hi Community Member,

Need your help to get some output.

Below is the detailed explanation and what result we need to get.

My actual data set is like below:- 

and based on the above dataset and I need to create one calcualted column [AvailableDate] just like below image,

In this column, if dates column is blank then it should consider next available date as you can see in the below pic.

[v-kaiyue-msft · Accepted solution]

Hi @AmitSaini ,

You can try this.

AvailableDate = 
VAR CurrentDate = 'Table'[Dates]
VAR NextDate = 
    CALCULATE(
        MIN('Table'[Dates]),
        FILTER(
            'Table',
            'Table'[Dates] <> BLANK() && 'Table'[ChangedDate] > EARLIER('Table'[ChangedDate])
        )
    )
RETURN
    IF(
        ISBLANK(CurrentDate),
        NextDate,
        CurrentDate
    )

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

[AmitSaini]

Hi @v-kaiyue-msft ,

Thanks for the solution. it works really well. Appreciate it.

[dharmendars007]

Hello @AmitSaini , 

Can you please try the below code ?

AvailableDate =
VAR CurrentRowDate = TableName[Dates]
VAR NextAvailableDate =
CALCULATE(
MIN(TableName[Dates]),
TableName[Dates] > CurrentRowDate
)
RETURN
IF(ISBLANK(CurrentRowDate), NextAvailableDate, CurrentRowDate)

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!

Thank You

Dharmendar S

LinkedIN 

[AmitSaini]

Hi @dharmendars007 ,

Thanks for the reply.

tried your code and it doesn't work. still giving the blank dates in available date column. See below pic.

[wdx223_Daniel]

AvailableDate=MAXX(FILTER(Table,Table[ID]=EARLIER(Table[ID])&&Table[Estimate]=EARLIER(Table[Estimate])&&Table[ChangeDate]>=EARLIER(Table[ChangeDate])),Table[Dates])

[AmitSaini]

Hi wdx223_Daniel,

Thanks for your reply.

I used the code suggest by you but it doesn't work.

see below output screenshot.