Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Can someone hlp on the following requirement
Consider below is the data in Table
Date Owner Filename Sharedwith Output
27/07/2020 dery@123.com test.docx abc@123.com 4
24/07/2020 dery@123.com test.docx xyz@123.com,123@abc.com xyz@mnc.com 4
24/07/2020 yarn @Anonymous.com test1.ppt 3
27/07/2020 yarn @Anonymous.com test1.ppt abc@123.com,zz@xyz.in 3
23/07/2020 barn@123.com test2.pdf xyz@mnc.com abc@123.com 2
Searching for the Owner and Filename in the complete table and if they are matched in other rows , a new coulmn(Output) to be created in the same table with count of Sharedwith users (Sharedwith even with comma seperated,space seperated)
Solved! Go to Solution.
@Anonymous
please try to use DAX to create a column(not in PQ).
output =
SUMX(FILTER('Table','Table'[Owner ]=EARLIER('Table'[Owner ])&&'Table'[Filename ]=EARLIER('Table'[Filename ])),len('Table'[sharedwith])-len(SUBSTITUTE(SUBSTITUTE('Table'[sharedwith],",","")," ",""))+1)
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |