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

Here the data

 

Order NumberOrder TimeUser NameBGR_ALL.Product NameBGR_ALL.CategoryValuePlatformPhone Number
1111101.01.2021OscaaarrriphonePhones155Facebook1925526
2222202.01.2021LunalenovoLaptops111Amazon1164070
3333303.01.2021EmilappleTablets69Google1618350
4444404.01.2021Lisa-MariaandroidPhones53Instagram1702213
5555505.01.2021LisamacbookLaptops90Ebay1571808
6666606.01.2021JansamsungTablets102Alibaba1701882
7777707.01.2021markusiphonePhones48Saturn1213889
8888808.01.2021RosalenovoLaptops16Facebook1892353
9999909.01.2021YO_OscarappleTablets168Amazon1925526
11111002.03.2021JoseandroidPhones161Google1164070
12222103.03.2021EmilmacbookLaptops112Instagram1618350
12222103.03.2021EmilmacbookLaptops112Saturn1618350
12222103.03.2021EmilmacbookLaptops112Facebook1618350
12222103.03.2021EmilmacbookLaptops112Amazon1618350
12222103.03.2021EmilmacbookLaptops112Google1618350
12222103.03.2021EmilmacbookLaptops112Instagram1618350
12222103.03.2021EmilmacbookLaptops112Instagram1618350
12222103.03.2021EmilmacbookLaptops112Instagram1618350
12222103.03.2021EmilmacbookLaptops112Instagram1618350
12222103.03.2021EmilmacbookLaptops112Instagram1618350
13333204.03.2021Lisa-MariasamsungTablets192Ebay1702213
14444305.03.2021LisaiphonePhones110Alibaba1571808
15555406.03.2021FeblenovoLaptops175Saturn1492420
16666507.03.2021MarkusappleTablets125Facebook1213889
17777608.03.2021RosaandroidPhones175Amazon1892353
18888709.03.2021Oscar32macbookLaptops100Google1925526
Anonymous's avatar
Anonymous
Not applicable
4 years ago

I still did not manage to solve that issue and would be super grateful if someone can assist! 🙂 

Thanks, community!