Forum Discussion

khaycock's avatar
khaycock
Helper I
6 years ago

Combining Data

Hello,   Is it possible to create extra lines based on data in other columns? I have three fields that I need to be one field so it can be a generic filter:   I'm conscious that amending th...
Need Help
az38's avatar
az38
Community Champion
6 years ago

Hi khaycock 

try a new calculated table

Table 2 = FILTER(
DISTINCT(
UNION(
SELECTCOLUMNS('Table',"Target List", 'Table'[Target List 1]),
SELECTCOLUMNS('Table',"Target List", 'Table'[Target List 2]),
SELECTCOLUMNS('Table',"Target List", 'Table'[Target List 3])
)
), NOT(ISBLANK([Target List])))
khaycock's avatar
khaycock
Helper I
6 years ago

How can I connect this to the rest of the data so I can use it to filter?