Forum Discussion
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 ...
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))
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))