Forum Discussion
Copy Column on a new table (with date)
- 8 years ago
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
- 8 years ago
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
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
- DavidB0238 years agoHelper III
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..
- ask4atish8 years agoAdvocate III
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
- DavidB0238 years agoHelper III
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