Workdays and festive days

[Lburgos]

Hello, 

I have been trying build a measure with workdays and festive days. 

I have discounted sunday in my variable but when I trie to discount another holiday it continues returning 1 in this case 

Laboral Day = 
VAR EsFinDeSemana = Dates[Number Day] IN {7}
VAR EsFestivo = 
    NOT ISBLANK(RELATED(TablaFestivos[Descripcion]))
VAR DiaLaboral = 
    IF(NOT(EsFestivo || EsFinDeSemana),1,0)
RETURN
    DiaLaboral

For example:

January 6 is holiday but it counts as 1....

My table is related with a table that contains holidays 

Can somebody help me please?

Thanks in advance. 

[v-yueyunzh-msft · Accepted solution]

Hi , @Lburgos 

Here are the steps you can refer to :

(1)Here are my test data :

(2)We can create a calculated column with this dax:

Column = var _isweekend = 'Date'[Number Day] in {7}
var _fest = RELATED('TablaFestivos'[Descripcion])
return
IF( _isweekend || _fest,0,1)

(3)Then we can meet your need , the result is as follows:

If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem.

Best Regards,

Aniya Zhang

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

[Lburgos]

Hello @v-yueyunzh-msft, 

Your approach it's fine, it works like a charm. 

Thanks!

Best Regards 

Luis