Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
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.