Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all, firstly i'm not sure if this can even be done.
i am working with a dataset in direct mode, so i can only create calculated measures via DAX. There is no transformation tab.
in this example, i have 5 rows of data
car | john |
car | glen |
car | tom |
bike | paul |
bike | john |
what i would like to achieve is this
car | john, glen, tom |
bike | paul, john |
so any help would be welcome
thanks in advanced
g
Solved! Go to Solution.
Hi, @glenmclaren
Please try to write the below for the calculated measure.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi, @glenmclaren
Please try to write the below for the calculated measure.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
hello, thanks for the response, it is close, but it puts all the agains each record
car | john, glen, tom, paul, john |
bike | john, glen, tom, paul, john |
how can i make it specific to the relevant records
car | john, glen, tom |
bike | paul, john |
thanks
Hi, @glenmclaren
Please check the link down below.
I am not sure what I have missed, but please correct me if I wrongly understood your question.
https://www.dropbox.com/s/dks31vlz4t2ofqz/glenmclaren.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.