Forum Discussion
SushmaReddy
Helper I
Helper IRemove Duplicates using DAX
Hi Team, I am developing a report where i need to use table visual and have to display the columns as shown below. Col1 Col2 Col3 Test1 .abc .123 .abc .234 ...
Mahesh0016
Super User
Super UserSushmaReddy I hope this helps you!THANK YOU!!
BKC =
IF (
ISINSCOPE ( Table1[Col1] ),
CONCATENATEX (
VALUES ( Table2 ),
". " & Table2[Col2],
UNICHAR ( 10 ) & UNICHAR ( 13 ),
Table2[Col3]
)
)
SushmaReddyHelper I
Helper IHi Thank you for the immediate response but i am still getting the same output.