Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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!
Solved! Go to Solution.
Hi @UBComma
Use DATE function to return proper date data type.
DATE ( 2022, 01, 26 )
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!
It happens to all of us. Good luck and have a great day
Hi @UBComma
Use DATE function to return proper date data type.
DATE ( 2022, 01, 26 )
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 13 | |
| 5 | |
| 5 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 25 | |
| 10 | |
| 10 | |
| 6 | |
| 6 |