Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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])
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.
@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])
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |