Column Filter for PowerBI Table

[hdbavda]

Hi,

I am attempting to display a set of documents from a SharePoint source into PowerBI. Some of the documents have expiration dates, and some are just "null" values. I am trying to hide the expired documents with the logic -- when an expiry date of a document is less than today, hide the document. But please note that I would like the null value docs to also display. I have tried using expiration date filters but so far been unsuccessful. Any guidance/help would be highly appreciated. Thank you

HD

[christinepayton · Accepted solution]

You could add a calculated column that flags the items you want to display. You can use an if-statement with an "or" (|| is "or" in DAX) that says if the field is greater than today date OR is blank, return true, else false (or use 0/1 as returns). Then you can use that in the filter.