Skip to content

Instantly share code, notes, and snippets.

@m-dekorte

m-dekorte/profileWithErrorCount.pq

Created January 26, 2025 11:18
Show Gist options
  • Save m-dekorte/eb2bb9947b57c8a68c88e64436047340 to your computer and use it in GitHub Desktop.
Save m-dekorte/eb2bb9947b57c8a68c88e64436047340 to your computer and use it in GitHub Desktop.
Download ZIP
profileWithErrorCount M function | Creates a table profile with statistics, including an error count for all columns.
Raw
profileWithErrorCount.pq
(t as table) as table =>
Table.Profile(t,
{{
"ErrorCount",
each true,
each Table.RowCount(Table.SelectRowsWithErrors(Table.FromColumns({_})))
}}
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment