Copy Column on a new table (with date)

[DavidB023]

Hi everybody !

I just need to copy a column from a table to another and my value are source of date like I show you in the following picture :

I try related or Summarize but nothing worked...

first table

second table

 I want the column of my first table on my second table ..

Best regards

Davidb023

[ask4atish · Accepted solution]

it seems you are creating measure. Creat new column then only column suggestions would appear in your syntax.

see screenshot of measure where suggestion didn't appear. 

and when i created column then suggestion appeared 

[ask4atish]

This can be achieved using related. First of all check whether date field is date type or not. If it is date type then create a new custom column=related(column which you want) and done. now create a table visual using your previous fields along with this newly created column. Make sure you have checked "show items with no data" if you want to show the same. see screenshot attached

[DavidB023]

@ask4atish

I already try to use function Related(column) but I can't choose a column from an another table, just column which are on the first table..

[ask4atish · Accepted solution]

it seems you are creating measure. Creat new column then only column suggestions would appear in your syntax.

see screenshot of measure where suggestion didn't appear. 

and when i created column then suggestion appeared 

[DavidB023 · Accepted solution]

I success to create new column with data from other table, I have created a relation between the two tables (with date column) and after that column from the other table appear in RELATED(). Thanks !

Best regards

DavidB023

[ask4atish]

Yeah. I forgot to mention that two tables should be linked with each other.