Forum Discussion
reynold522
Helper II
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 (Date(2021,9,15), TODAY()) table 1,2 and 3 out of 4 data tables have two co...
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.
tamerj1
Community Champion
Community ChampionHi 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.
reynold522Helper II
Helper III 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.