Combine arrays in dax measure

[Analitika]

How to combine arrays?

VAR Arr1= {"6203","6303","6304","63040","630401"}

VAR Arr2= {"6300","63012","63046","63126"}

VAR Arr3= {"63","612","636","66"}

VAR combine = COMBIN(Arr1,Arr2,Arr3,...)  ' excpected {"6203","6303","6304","63040","630401","6300","63012","63046","63126","63","612","636","66"}

[Fowmy · Accepted solution]

@Analitika 

Use UNION.

Go to modeling Tab > New Table and paste the code

Table 2 = 
VAR Arr1= {"6203","6303","6304","63040","630401"}
VAR Arr2= {"6300","63012","63046","63126"}
VAR Arr3= {"63","612","636","66"}

return

UNION(
    Arr1,Arr2,Arr3
)

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn