Forum Discussion
How do I create a visual using time intelligence if the table has no date data stored on it?
brs09j you can do that, what about merging the tables? what information is in the 2 tables?
Hey,
if your table has no date column, than you may can build such a column, maybe there is year and a month column, from this you can "build" your date column.
If no such columns are available, you may have to consider to rebuild your data import. Often this "date" information is hidden in tabs of excel sheets or in the filename.
If you do not have such information available, you have to use some other kind of wizardry ;-)
Regards
Theres two tables. One has dates and the other does not. However, when I try to use the dates from Table A wih Table B (no dates) the line graph looks bad. I think I need to create a date table and join it to Table A and then change the relationship of Table A and Table B to be bidirectional filtering?
brs09j you can do that, what about merging the tables? what information is in the 2 tables?
I was wondering about that 2 but I don't really understand best practice with that. When do I want to merge tables?
Both tables have a ton of columns and some will overlap. Sales and Storage.
