Forum Discussion
Helper IIfilter data with time stamp from dim date
Hi All,
I have 5 tables: 4 data tables and 1 Date tables.
data table I write dax code as follows:
DimDate = CALENDAR
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!
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.
2 Replies
- tamerj1
Community Champion
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.
reynold522I 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.