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

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