Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculated Column based on multiple filter criteria

Hello, How to create a calculated column flagging whether or not a particular calendar Week is shared between two calendar months or not (end of month scenario), without considering Saturdays and Su...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous ,


    Var _week = [Week]
    return
    if(calculate(distinctCOUNT(Dim_Date[Month Number]), filter(Dim_Date, Dim_Date[Week] =_week && not( Dim_Date[Weekday] in{"Sun", "Sat"}))) =2, "Yes", "No")

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous 

Many thanks for taking time out to explain this with example. Indeed it should be the inner ALLEXCEPT() removing all other context filters. Though I do need to understand these nuances in more detail!

Regards

Nirmit