Forum Discussion
Show Missing Values in Matrix as Text
Hello, I'm creating a dashboard for monitoring whether documents are up to date in our database (web based, linked via API) and can't figure out a way to show missing data as missing. Data: Row...
Can you provide your input ? There are several ways for that 🙂
Do you mean the file itself? Or what a row in power query looks like?
If you mean power query, the format is at follows:
parentID/documentType/Document Versions.asOf/DateDiff (today-as of date)/OverDue (assigned depending on document type and date diff)
Matrix:
I use first OverDue so that I only show the most recent document version