Measure

[RMoodliar]

Good day,

Please advise the best function to use in measure to check for the completion of information across all columns. I have for example user personal infromation (Name, suranme, ID number, address, and more) however not all this information is available and I would like to measure who has completed all the reqiured fields and who have not (blank cells or Select Option). to make this more complicated I have to get the personal information form 3 different data lists.

[ibarrau · Accepted solution]

Hi. Measures are calculations to get numbers. The issue you describe sounds like you need to know which rows are not completelly loaded and contain at least one blank. If I'm correct and that's the case, I would say that you need a new column as a flag to filter rows. A column created at power query checking if one of the columns is blank then the row is uncompleted.

Maybe you can also try an external tool. It's DataQualityReport. It will shown a report on how the data is loaded. I'm not sure the report will show you all the things you need, but you can try it. Link: https://github.com/ladataweb/data-quality-report/releases/tag/v0.1

I hope that helps,