Forum Discussion
June 2019 Update - Cannot Filter Null Dates
Prior to the June 2019 update, I was able to filter out null date values using the filter. However, that is no longer working. Has anyone else encountered this? Null is a valid value for this date column.
I have tested this in Power BI without the June 2019 update and it works as expected - that is, I can replace the null value or filter the table.
The below pictures show the columns. As shows, the null value is present.
Even if I try to do a replace, it doesn't replace the value = Table.ReplaceValue(#"Added Conditional Column",null,#date(1999, 1, 1),Replacer.ReplaceValue,{"resolution_dt"}))
I have confirmed that in the June update that you can still filter out the null values on a text field.
Is there a link to download the May 2019 version so I can keep developing until this is fixed? I have confirmed in another PBIX on a machine which did not update that this functionality works.
1 Reply
- v-lili6-msftCommunity Support
hi, Anonymous
You could download Prior Power BI Version in here:
May 2019 Update (2.69.5467.1251)
( We only archive the English versions of Power BI Desktop.)
https://docs.microsoft.com/en-us/power-bi/desktop-latest-update-archive
And there are other version provided in some blog.
https://zenatti.net/2017/07/04/power-bi-previous-versions/
I also happen to have a lower version, click here to download.
Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.
Best Regards,
Lin