filter data with time stamp from dim date

[reynold522]

Hi All, 

I have 5 tables: 4 data tables and 1 Date tables.
data table I write dax code as follows:
DimDate = CALENDAR

(Date(2021,9,15), TODAY())

table 1,2 and 3 out of 4 data tables have two column for time, 

• one column is date/time e.g., 1/10/2023 5:45:30
• the other one is date   1/10/2023

if I use dime date connect with data column with many to one cardinality to filter corresponding data in table 1, 2 and 3, it works

table 4 only has one column with date/time format, I add a new column equal to this one and convert it to date format.

however, I can not use dime date to filter this table, it doesnt work.

any idea to help?

Thanks in advance!

[tamerj1 · Accepted solution]

Hi @reynold522 

What do you mean by "convert it into date format"?

you need to extract the DATEVALUE by creating a new column using DAX or transform the same column to date only using Power Query. 

[reynold522]

I did exactly as you suggested however, it didnt work at that time. 

However, I realized that my data is realtime queueing data, that could be the problem. 

I used sql create a new column in snowflake. 

then it works.

However, still thanks for your reply.