surpass holidays in calculated column

[Etienne_1995]

Hi

I would like to calculate a column, where the date gets checked, if it is a holiday or not. When it is a holiday-day it should additionaly, to the already existing operation, add 1 extra day. But the holidays are in a seperate table.

But somehow I don't know how to combine information out of the tables in one calculated column.

the current calculation looks like this:

calculated Date = 'List'[EBP_Liefertermin] - 'List'[Vorlaufszeit in Tagen]

when there is a 1 in the column "holiday", it should get used in the calculated column to add 1 day to the calculation.

sadly I cannot share the file, since I'm not allowed to share it.

Any help would be highly appreciated.

Have a nice weekend

[tamerj1 · Accepted solution]

Hi @Etienne_1995 

please try

calculated Date =
VAR CalcDate = 'List'[EBP_Liefertermin] - 'List'[Vorlaufszeit in Tagen]
RETURN
IF ( RELATED ( dynamic_calendar[holiday] ) = 1, CalcDate + 1, CalcDate )

[Etienne_1995]

I would like to have a calculated column, which calculates 
'List'[EBP_Liefertermin] - 'List'[Vorlaufszeit in Tagen]

when "holiday" is = 0

but when "holiday" is = 1 I would like to do the same calculation, just with the addition to add an additional day for each 1 in the "holiday" column.

For example when there are 5 dates and every date has a 1 in the column "holiday", the calculation should ad 5 days extra to the normal calculation.

I hope this helps you to better understand my problem.

[FreemanZ]

how would you expect your result look like?