topic Re: Can't Understand these Date Filter Results in DAX Commands and Tips

Can't Understand these Date Filter Results

UBComma — Sun, 20 Feb 2022 13:14:44 GMT

Can anyone help me understand why I am seeing these results? I am trying to find the date when I reach a goal volume (1200ml) but the date has to be after 1/26/22 and I can't seem to be able to filter out the earlier dates. I can't understand why the filter below is still showing dates before this date. I can provide the PBIX file if you're interested and think it will help figure this out.

Thank you!

Re: Can't Understand these Date Filter Results

tamerj1 — Sun, 20 Feb 2022 13:39:50 GMT

Hi UBComma

Use DATE function to return proper date data type.
DATE ( 2022, 01, 26 )

Re: Can't Understand these Date Filter Results

UBComma — Sun, 20 Feb 2022 13:42:55 GMT

Oh, I feel silly. That's genius and someday I'll be able to figure that out on my own. Thank you for making me a little smarter today!

Re: Can't Understand these Date Filter Results

tamerj1 — Sun, 20 Feb 2022 13:44:39 GMT

It happens to all of us. Good luck and have a great day