Monitor Blanks in Mapping files

[poojag820]

Hi,

My request is little different. 

My client have some mapping report in which there are many blanks values which are reflecting in the end data in dashboard. 

They want us to develop something so that they can monitor blanks in there mapping files and handle them accordingly. 

Any suggestions would help. 

Thanks

[Joe_Barry]

Hi @poojag820 

Do you want to check the whole table or just a column? I only know how to check ona  column basis. Below is a template you can use, just replace the table and column names with yours.

Blanks = ISBLANK('Table'[ColumnName])

Joe