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_...
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
Icon for Super User rankSuper 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
      Icon for Super User rankSuper 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)
      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Thank you! 

        That looks very promising. When I fit that into my table however, it does not show my anything for the p variable. It just returns blank values.

        As a measure it does not work because it does not recognize the index column.

        What am I doing wrong?

         

        Thanks !