Forum Discussion
Solved
Null Values Date Data Type
I am working on a dataset I inherited and I am seeing an issue that I don't know exactly how to fix. The underlying SQL table is a list of warehouse events (picking, packing, etc), and there is a col...
Hi Xaraja
Power BI can accept null or blank values in a date data type column. In Power Query Editor, it displays null. In Power BI Desktop, it displays blank. In below image, it shows the same table in two places.
What is the error message do you see? If the report is working, perhaps the cause is not the null values in date columns. Can you please show the error message after removing sensitive info?
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
You can change the formulas so they don't produce errors (preferred - use try ... otherwise ...) or you can mass replace all errors with nulls.