Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Dedupe ID - Keep most recent record

I have a list of Visitor IDs to a website for a specific timespan.  For purposes of summarizing the data, I would like to dedeupe the IDs in the list, keep only the timestamp of the most recent visit...
Need Help
Show and Tell
  • Vvelarde's avatar
    Vvelarde
    8 years ago

    Anonymous

     

    (DAX(SUMMARIZECOLUMNS(analytics_clickstream_201802[visid_comb);"LastDate":MAX(analytics_clickstream_201802[date_time]))

    )).

     

    Replace : with ; 

     

    If you have problems with ; replace it with , (This is for regional settings)

     

    Regards

    Victor

     

     

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
8 years ago

Anonymous

 

(DAX(SUMMARIZECOLUMNS(analytics_clickstream_201802[visid_comb);"LastDate":MAX(analytics_clickstream_201802[date_time]))

)).

 

Replace : with ; 

 

If you have problems with ; replace it with , (This is for regional settings)

 

Regards

Victor

 

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Neither change succeeded.

 

Assuming I followed your instruction properly.

 

Column = SUMMARIZECOLUMNS(analytics_clickstream_201802[visid_comb]);"LastDate",MAX(analytics_clickstream_201802[date_time]))

 

The syntax for ';' is incorrect. (DAX(SUMMARIZECOLUMNS(analytics_clickstream_201802[visid_comb]);"LastDate",MAX(analytics_clickstream_201802[date_time])))).

  • Vvelarde's avatar
    Vvelarde
    Icon for Community Champion rankCommunity Champion
    8 years ago

    Anonymous

     

    Ok.

     

    Replace ALL ; with , Dont Mixed.

     

    And Use a Modeling - NewTable Not a New Column.

     

    Regards

     

    Victor

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Vvelarde

     

    So I think what you're suggesting: 

     

    1.  Modeling>New Table

    2.  Add Dax Statement: 

     

    Table =  SUMMARIZECOLUMNS(analytics_clickstream_201802[visid_comb]),"LastDate",MAX(analytics_clickstream_201802[date_time]))

    3.  Then what?

     

    Thanks.

  • Vvelarde's avatar
    Vvelarde
    Icon for Community Champion rankCommunity Champion
    8 years ago

    Anonymous

     

    This will create you a new Table with the data.

     

    Regards

     

    Victor

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thank you.