Forum Discussion
RezaAzimi
8 years agoAdvocate I
Data profiling
Hi all,
I want to profile every single data table I have in my powerbi report. By data profile I mean somehting like this:
are there ways to make a data profile view in powerbi? dax measure or calculated columns?
alternatively, you can also recommend other data quality tools that can handle such tasks since I find it bit difficult to achieve this result in powerbi.
3 Replies
- v-chuncz-msftCommunity Support
- RezaAzimiAdvocate I
HI,
could you please provide some examples on how to do with table functions in DAX?
- stretcharmMemorable Member
Try the table Profile command.
Add a step based on the previous step or use the advanced editor
= Table.Profile(Source )
https://msdn.microsoft.com/en-us/query-bi/m/table-profile
https://blog.crossjoin.co.uk/2016/01/12/descriptive-statistics-in-power-bim-with-table-profile/