Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Searching data in common from two list

Hi everyone, I have a question. I have this fact Table that is about memberships from a gym. Customer Start Date End Date 1 01/03/2023 28/02/2024 2 01/04/2023 31/03/2024 3 01/05...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Ahmedx , thanks for the reply.

     

    I don't understand how this is going to help. What I see in those topics, is to count how many dates are in both list.

     

    What I need is something like this:

    CALCULATE ( [Distinct Count Customers]
            , [one of the dates in the List of the dates selected from dimDates]
              in
             [List of Dates between Start Date and End_Date]
    )

     

    [one of the dates in the List of the dates selected from dimDates]: This list is going to be all the dates between 1st and 31st of March 2023

     

    [List of Dates between Start Date and End_Date]: This list is going to be for each line from the fact that I wrote above.