How to get "Greater than today" Date Column?

[Anonymous]

It's quite complicated to get a new column which is Greater Than Today compared to "Deadline" column?

What would be the formula for a Custom Column if the existing date column is Deadline and I have to get all the records greater than today marked "Ongoing" in the new Column.

[amitchandak · Accepted solution]

@Anonymous , Not very clear try like

Create a new column

Flag = if ([date] >= today(), "Ongoing","Past")

[v-deddai1-msft · Accepted solution]

Hi @Anonymous ,

It seems you want to create a new column to show if the task is ongoing or done. Please refer to the following calculated column:

Status = IF('Table'[Deadline]>Today(),"Ongoing","Done")

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

Best Regards,

Dedmon Dai

[amitchandak · Accepted solution]

@Anonymous , Not very clear try like

Create a new column

Flag = if ([date] >= today(), "Ongoing","Past")