Forum Discussion
erbabu
8 years agoNew Member
How to: using one column (customer) for multiple date columns in a fact table
Hi I have the below table. Customer, DateSold, first-purchasedate-by-customer (calculated column based on DateSold) I have associated DateSold and first-purchasedate-by-customer to DateDi...
- 8 years ago
Update:
I was able to achieve it by creating a new table with a copy of data from parent table (first-purchasedate-by-customer,Customer) and associating this table first-purchasedate-by-customer to DateDim table & created visualization.
erbabu
8 years agoNew Member
Update:
I was able to achieve it by creating a new table with a copy of data from parent table (first-purchasedate-by-customer,Customer) and associating this table first-purchasedate-by-customer to DateDim table & created visualization.