No Transaction Date in Fact Table

[Anonymous]

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.

[v-shex-msft]

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

[amitchandak]

@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

[Greg_Deckler]

@Anonymous - Create a calculated column like:

Date = TODAY()

?