Forum Discussion
khaycock
Helper I
Helper ICombining 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...
az38
Community Champion
Community ChampionHi 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])))
khaycockHelper I
Helper IHow can I connect this to the rest of the data so I can use it to filter?