Data From fact table

[Anonymous]

Hi, My one table has column called name like:

1. a

2.b

3.c

4.c

5.d

6.a

I would like to have distinct name in another table called table 2.

Both table are connected via production date column.

[dax · Accepted solution]

Hi preetam,

I am not clear about your requirement, if you want to create a table with distinct value of name, you could try to use below expression to create a table like below

Table 2 = VALUES('Table (2)'[name])

If this is not what you want, please inform me more detailed information (such as your sample data and your expecting output). Then I will help you more correctly.

Best Regards,

Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.