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

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.

      • 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
)