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

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 !