Forum Discussion
Data quality check
I think the most easy thing for you to do is the following then:
Make a card, add the column you want to count values for. Right click on the field and set the values to "Count"
Add the same column as a filter to the card, here you can choose which values you want to count.
/M_illum
I would deal with empty spaces in the query editor. This could be done by the trim function Text.Trim - PowerQuery M | Microsoft Docs
It removes extra spaces, and rows containing only a space will be counted as blancs
I dont want to edit the dataset or anything. I just want to visualize the state of the dataset. So i want to show in some card visuals
- the amount of rows
- the amount of null values
-the amount of empty values
I think the most easy thing for you to do is the following then:
Make a card, add the column you want to count values for. Right click on the field and set the values to "Count"
Add the same column as a filter to the card, here you can choose which values you want to count.
/M_illum
Thanks!