Relationship with Dates

Question

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? thanks

eric_zhang · Answer

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

&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
Anonymous
The first picture tells the story, pay attention to its foot.
&nbsp;
TABLE: Age Group(42613 rows) COLUMN:Birthday(42612 distinct values)
&nbsp;
To find out the duplicates, try to create a new table
&nbsp;
new table =
FILTER (
    SUMMARIZE (
        'Age group',
        'Age group'[Birthday],
        "cnt rows", COUNTROWS ( 'Age group' )
    ),
    [cnt rows] &gt; 1
)
&nbsp;

gileswalker · Answer

Anonymous&nbsp;- 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.&nbsp;Giles

anonymous · Answer

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

anonymous · Answer

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

gileswalker · Answer

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

Forum Discussion

Relationship with Dates

10 Replies

Related content

Date relationship issues

Relationship

Relationships

Fact Table Multiple Dates Relationship with Dimension Date

Relationship Issue