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

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 !