Issue with Date

[Anonymous]

Hi Experts,

I have two table sales fact and column name is  timestampUTC  and Day table is date dim table. I have created Date dim (day,month,year) table by using timestampUTC column from sales fact, if i am trying to select DAY from date dim table i should get only 28mmyy.... from fact table , but i am getting all the dates from fact table (timestamputc column). hpw to resolve it . please help

[amitchandak]

You have time stamp in fact date.

Create a date column and join it with date dimension

date = Table[Timestamp].date

OR

date = date(year(Table[Timestamp]),month(Table[Timestamp]),day(Table[Timestamp]))

[Anonymous]

sorry i didnt understand.

i have created date column in data table by using fact.timestamp

Date table--> CALDate = ALLNOBLANKROW(Sales[timestampUTC])

my report is based on hour,day, week and month. so i need timestamp as well in both the tables

[amitchandak · Accepted solution]

What kind of join these two table have.

put both time stamp in table with this option on date dimension and check how many null you have

[Anonymous]

I am able to join only one fact table.

table with col

date table = ddmmyyyhhmm

sales facts = ddmmyyyhhmm

Target facts=ddmmyyyhhmm

joins

date table1:M sales facts (both)

now i need to join date table to target table  if i do same join as i did with sales facts its not working

[V-lianl-msft]

Hi @Anonymous ,

Please try to create calculated columns in two tables to get "day", and establish a relationship for two tables based on these two columns.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.