Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Relationship with Dates

In order to have "Age group" for my data set, i've created a help table with "birthday" as unique dates.  But when i try to link it to birthday, i keep telling me it's not unique.  Any1 knows why...
Need Help
GilesWalker's avatar
GilesWalker
Skilled Sharer
10 years ago

Anonymous - I have had something like this happen before with Excel documents. Go into the query editor and in the Birthdays file have a look at the bottom of the table and see if there are any values there. I have foud sometimes there are a couple random rows at the bottom and these cause the issue.

 

Giles

Anonymous's avatar
Anonymous
Not applicable
10 years ago

GilesWalker

any easy way to go to the bottom of the page? as the birthday are covers from 1900 to today. very long list.  thanks.

 
  • GilesWalker's avatar
    GilesWalker
    Skilled Sharer
    10 years ago

    Anonymous - you can click on the filter button and see if any thing other than numbers shows up. otherwise just scroll all the way.

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      GilesWalkeri'm unable to see all the values from filters, as it's "limit of 1000 values reached. but looks like it's all dates.

    • GilesWalker's avatar
      GilesWalker
      Skilled Sharer
      10 years ago

      Anonymous have you tried in the table view in the Power BI desktop? On the left hand side there is a button to see the tables, this will allow you to scroll to the bottom.

      • Anonymous's avatar
        Anonymous
        Not applicable
        10 years ago

        GilesWalker i'm unable to see the bottom from data view or query view as it's too many rows.