Forum Discussion

timazarj's avatar
timazarj
Icon for Helper II rankHelper II
5 years ago
Solved

Multiple Date filter/ relationship

Hi, My model is simple, a date table for filtering monthly reports, PL Service which is recording the services, Inserted date, Effective Date, & Closing Date, AM Table for service person name and ID...
DAX Commands
USERELATIONSHIP
  • amitchandak's avatar
    amitchandak
    5 years ago

    timazarj , can you check InsertedDate has a timestamp. If so join might fail

     

    create a date like 

     

    Date = [InsertedDate ].date
    or
    Date = date(year([InsertedDate ]),month([InsertedDate ]),day([InsertedDate ]))

  • Anonymous's avatar
    Anonymous
    5 years ago

    Hello timazarj 
    You can try few things.
    1. Check the column format and make it date.
    2. Mark the date table as a date table.
    3. Check the min and max of both the Inserted Date and Effective Date and create the date table accordingly using min and max values.

    4. Create an active relationship with the inserted date and modify the measure accordingly and check.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello timazarj 
Can you please share your pbix file or sample data after removing the sensitive data?

  • timazarj's avatar
    timazarj
    Icon for Helper II rankHelper II
    5 years ago

    Unfortunately no.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hello timazarj 
      You can try few things.
      1. Check the column format and make it date.
      2. Mark the date table as a date table.
      3. Check the min and max of both the Inserted Date and Effective Date and create the date table accordingly using min and max values.

      4. Create an active relationship with the inserted date and modify the measure accordingly and check.