Forum Discussion
No Transaction Date in Fact Table
Hi all,
Does anyone know how to create a transaction date in the fact table, if it doesn't yet exist?
I have a fact table and multiple lookup tables with successful one-to-many relationships. I have got stuck however on connecting the Calendar table to the fact table; there is no Date to connect to in the fact table.
I understand this is limited information, but just looking for a general guidance to start with (e.g. is this a frequent issue)
Thanks.
3 Replies
- Greg_Deckler
Community Champion
Anonymous - Create a calculated column like:
Date = TODAY()?
- amitchandak
Super User
Anonymous , there is no date, you do nor need date join. Do you have month, year, qtr year. etc. you can create date from that
refer:https://youtu.be/cJqgphIHXz8
Dax way: https://youtu.be/yPQ9UV37LOU?t=100
Hi Anonymous,
It sounds like you did not have any valid DateTime value in your table, is there any part of data values? (e.g. year, month, day...)
If this is a case, you can add an index to your table and create a dummy start date based on these date parts and use the index as interval to generate the list of date value into your tables.BTW, it will be helpful if you share some dummy data to help us clarify your data structures.
Regards,Xiaoxin Sheng
