Forum Discussion
Copy Column on a new table (with date)
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
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
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
5 Replies
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
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