Create new Date Column

[ChoiJunghoon]

 I want to create new column at the "DataTable". 

If the Startdate is in Holiday, I want to create a new column by converting it to the day the holiday ended.

Pdix file 

[Greg_Deckler · Accepted solution]

@ChoiJunghoon - Perhaps:

Applied Holiday =
  VAR __Date = DATE(YEAR([StartTime]),MONTH([StartTime]),DAY([StartTime]))
  VAR __Remark = LOOKUPVALUE('CalendarTable'[Remark],[Date],__Date)
RETURN
  IF(__Remark <> "Holiday",__Date,
    MINX(FILTER('CalendarTable',[Date]>__Date && [Remark] <> "Holiday"),[Date])
  )

[ChoiJunghoon]

Thank you So much

[Ashish_Mathur]

Hi,

That download link does not work.

[lbendlin]

so instead of FIRSTNONBLANK() you are looking for "first blank" holiday column value for a given datetime value

- Take your datetime value

- convert it to a date

- in the dates table find the MIN(date) that is greater than or equal to the date in step 2 where the holiday column is blank

You can do this via Calculate() or Minx()