Forum Discussion

Matt22365's avatar
Matt22365
Resolver III
6 years ago
Solved

Relationship issue between date fields

Hi I hope someone can help I have created a relationship between a date table and a database. The link is between "date" (from date table) and "date closed" (fromthe database) The aim is to have a ...
Need Help
  • Matt22365's avatar
    Matt22365
    6 years ago

    Hi

    Thanks for your support

    The reason it was only matching 11 entries was due to the Database table "Date Closed" being retrieved in Date/Time format. Once I edited this it all worked.

    Thank you for your time helping on this

    Matt  

Matt22365's avatar
Matt22365
Resolver III
6 years ago

Hi

Thanks for getting back to me

I have created a link between "Date" and "Date Closed".

I havent created a measure for this calculation as the relationship between the Date and Stats tables is working correctly (without one) i.e. a card to count the amount of line where the published date meets the criteria of a sliced based on the Date column 

It appears that the link is working as 11 of the 2019 rows are counted using the date table filter (you can see these in the previously uploaded picture), however this number should be in the thousands

Thanks

Matt 

v-kelly-msft's avatar
v-kelly-msft
Community Support
6 years ago

Hi Matt22365 ,

 

So how do you make it appear in the table for the 11 lines?As in my table ,I use a calculated column to link the 2 tables,and everything runs ok,as you can see below:

 

 

So let me know more details,I will try my best to find out the problem.

 

 
Best Regards,
Kelly

  • Matt22365's avatar
    Matt22365
    Resolver III
    6 years ago

    Hi

    Thanks for your support

    The reason it was only matching 11 entries was due to the Database table "Date Closed" being retrieved in Date/Time format. Once I edited this it all worked.

    Thank you for your time helping on this

    Matt