How to ignore specific dates and nulls

[mitchmoore2]

I'm working with a CSV data set that contains both nulls and the date "2099-12-31" that should also be treated as a null. How can I transform the data set to make it so Power BI doesn't return any data meeting these conditions when using a date slicer?

[MFelix · Accepted solution]

Hi @mitchmoore2,

I believe that the best way is going trough the query editor and filter out this two values that way you only get in your data in PBI the values you want and no need of additional filters/slicers on your reports.

Regards,

MFelix