Forum Discussion
adiletsh
3 years agoFrequent Visitor
How to divide column values into horizontal values
Hello everyone
I need to get visual element like this:
To do this I have 2 columns with values:
1)before the bracket "БП2", "БП1" and in bracket
2) in bracket
first column values:
second column values:
So, The working principle of two columns is : "БП1" may have 12 numbers in second column but it doesn't work in the opposite direction. Unique quantity of first column values 12 its From "БП1" To "БП12". Every first column values have ("БП1") have 12 numbers in second column.
Selected date filters two columns and I will get that values in visual element in a table form.
So, my problem is to do this visual element.
Thank you in advance.
is this what you want?
Measure = CONCATENATEX(distinct('Table'[column2]),'Table'[column2],",")pls see the attachment below
3 Replies
- ryan_mayuSuper User
is this what you want?
Measure = CONCATENATEX(distinct('Table'[column2]),'Table'[column2],",")pls see the attachment below