Measure - IF statement

[Anonymous]

Good morning

I have a table with public holidays from various countries and it has an index column and it has a relationship with the DIM Date on the date columns. I also have another table with shift data and that has relationship with the date table on the date columns. 

I would like to write a measure (not add a column) to check if the employee worked on a public holiday. I know I can merge the tables within Power Query and get the result I want, but I would like to know if it is possible within DAX

Thanking you in advance

Joe

[Anonymous]

Thank you @amitchandak 

[amitchandak · Accepted solution]

@Anonymous , Try to create a new column in date column

Holiday = related(holiday[Holiday] )

or

Holiday = maxx(filter(holiday, date[Date] = Holiday[Date] ) , holiday[Holiday] )

You need create a measure

calculate(Countrows(Fact) , filter(Date, Date[Holiday] =1))