Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Measure - IF statement

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

Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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))

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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))