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
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.

Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
10 years ago
Anonymous wrote:

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

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Anonymous

The first picture tells the story, pay attention to its foot.

 

TABLE: Age Group(42613 rows) COLUMN:Birthday(42612 distinct values)

 

To find out the duplicates, try to create a new table

 

new table =
FILTER (
    SUMMARIZE (
        'Age group',
        'Age group'[Birthday],
        "cnt rows", COUNTROWS ( 'Age group' )
    ),
    [cnt rows] > 1
)