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

 

Yes, this should be Work.

 

It takes the Visitor ID (after the concatenation was made it). The visitor ID is a calculated column right?

 

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Vvelarde

 

This is the statement I am using for the ID creation:

visid_comb = CONCATENATE(analytics_clickstream_201802[post_visid_low],analytics_clickstream_201802[post_visid_high])

 

This is your recommendation, modified for the table:

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

 

This is the error message when I apply your suggestion, and I am not sure where my error is:

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

)).

 

Appreciate all of the help.

 

 

  • 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