Forum Discussion

SJCee's avatar
SJCee
Frequent Visitor
3 years ago

Count Number of Rows if Date is Between Two Columns

Hello,   Been scratching my head for days on this one, any help much appreciated!   I have a Calendar Table that lists every date in 2023.   I have another table (Table 1) that has three column...
SJCee's avatar
SJCee
Frequent Visitor
3 years ago

Thanks Greg_Deckler , applied the above formula but now not returning any results. Let me know if it is easier if I start a new thread with this question.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

SJCee Might be better that way so that the original question can be marked as answered. So, the idea behind this is that you would use this Complex Selector in a second visual with your Customer ID column in it. This measure would be in the Filters pane and set to filter for 1. In theory, when you clicked a Date in your original visual the second visual would get filtered to the ID's where that measure returns 1.

  • SJCee's avatar
    SJCee
    Frequent Visitor
    3 years ago

    Thanks Greg_Deckler makes sense on the ComplexSelector. Before I create a new thread, I have notied quite a few of the numbers on the measure are actually incorrect on the Measure.

     

    I have noticed on the measure forumla [CustomerId] on line 4 ("VAR __Result") is underlined in red and when I hover over it, it says "Parameter is not the correct type. Cannot find name "[CustomerId]"). CustomerId definitely matches the exact column name, so not sure what the issue is.