Filtering by date returns no results

[EHQG]

Hi All,

I am having an issue with my date table.  When I filter the dates I cannot get "01/04/2022" to return same for "01/04/2022".

Those dates exist, but when I try to filter for dates that equal "01/04/2022" it does not return any results. When I filter by dates between "01/04/2022" and "24/04/2022", it will return everything but "01/04/2022". I can filter by the dates within the query editor.

The date exisits in the column

Filtering for dates that equal 01/04/2022

Filtering on or after 01/04/2022 and on or before 24/04/2022

Any help is much appeciated.

Cheers

[v-chenwuz-msft]

Hi @EHQG ,

Did you get your problem solved, and if so, please share your method. If not, as @amitchandak  said, it is the precision of the timestamp that is causing the mismatch. You can try converting them with format().

New date = Format('table'[date], "dd mmm yyyy")

Then change the column type to date and it maybe works.

Best Regards

Community Support Team _ chenwu zhu

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

[amitchandak · Accepted solution]

@EHQG , Change datatype to datetime (Fact Table date column) and choose a format with time. Check if there is timestamp other than 00:00 or 12:00AM

if yes, then create a date column use that in join/filter, and try

Date 1 = Datevalue([date])