Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Matching Users across Platforms

Hi Community and PowerBi Masters,   I am currently working on an analysis for which I try to understand the consumer behavior in detail.  The corresponding data that I have is (name of table: All_...
lbendlin's avatar
lbendlin
Super User
4 years ago

that's a bold assumption 🙂

Please provide sanitized sample data in usable format (not as a picture - inserting it into a table would be good) .

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hello lbendlin ,

 

was the data that I provided in the table form of any help?

I would really appreciate help here, dont manage to find a starting point.

 

Thanks a lot!

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    Do you want to record only true platform switches, or do you also want to see the events where they purchased from the same platform multiple times in a row (like Emil and Instagram)?

     

    See attached for a sample implementation

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thanks a lot! 

      Seeing the events where thez purchased from the same platform multiple times in a row would also be nice! Thanks for asking. 

      I unfortunately can not open the report because I can not download the latest version of PBI currently. Would you be able to share it in another format? That would be great!

      Thanks a lot!

      • lbendlin's avatar
        lbendlin
        Super User
        4 years ago

        Here's the result:

        and here is the DAX :

         

        Came from = 
var i = 'Table'[Index]
var p = CALCULATE(max('Table'[Platform]),ALLEXCEPT('Table','Table'[Phone Number]),'Table'[Index]=i-1)
return if('Table'[Platform]=p,BLANK(),p)