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  

amitchandak's avatar
amitchandak
Super User
6 years ago

Refer my blog, how to handle two dates using same time dimension

HR-Analytics-Active-Employee-Hire-and-Termination-trend

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

  • Matt22365's avatar
    Matt22365
    Resolver III
    6 years ago

    Morning

    Thanks for getting back to me, I have used your article for a different issue but I think this requires a more simple fix

    I have attached a pictue of my relationships (its a little complex as I link between a lot of tables). The only issue I am having is the highlighted blue line. I want the  "Date" Table to filter the "Database" table then a card to count the amount of lines where the date closed matches the filter. e.g. in 2019, how many lines of the database have been closed

    Thanks

    Matt 

     

    Edit - to add a bit more information, if I make a table with both date fields in some dates to match up but not all, see picture below

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

      Hi Matt22365 ,

       

      Just now I used my sample data to test on your provided relationship schema,but I cant find what your problem is,as everything runs fine in here:

       

      So now pls advise me what the measure you are using?And in the table "Database",which column are you filtering with?

      For my .pbix file, pls click here.

       

      Best Regards,
      Kelly

      • 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