topic Re: How to get Next available date in calculate column in DAX Commands and Tips

How to get Next available date in calculate column

AmitSaini — Mon, 09 Dec 2024 06:55:04 GMT

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.

Re: How to get Next available date in calculate column

wdx223_Daniel — Mon, 09 Dec 2024 07:03:17 GMT

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

Re: How to get Next available date in calculate column

AmitSaini — Mon, 09 Dec 2024 07:14:47 GMT

Hi wdx223_Daniel,

Thanks for your reply.

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

see below output screenshot.

Re: How to get Next available date in calculate column

dharmendars007 — Mon, 09 Dec 2024 08:15:02 GMT

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

Re: How to get Next available date in calculate column

AmitSaini — Mon, 09 Dec 2024 09:19:11 GMT

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.

Re: How to get Next available date in calculate column

Anonymous — Tue, 10 Dec 2024 01:29:08 GMT

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.

Re: How to get Next available date in calculate column

AmitSaini — Tue, 10 Dec 2024 04:32:57 GMT

Hi Anonymous ,

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