Power BI - Beyond Table Profile Stats

[helalm]

I have used Table.Profile function for most part. Now, the requirement somewhat changed and I need to get more stats on multiple variables. For example, on continuous variables such as age, total scores, etc... I need to get N, Mean, Median, STDV, Min, Max, and IQR (Interquartile range), and Box plot graph by let's say sites or clinics (See attached BoxPlot picture and formatting). For categorical, N, column % by let's say sites or clinics ((See attached Category example picture and formatting). I can create these measures easily and format the report accordingly for one variable at a time. However, I have 80 different data sets with more than 1500 variables.
Therefore, creating these measures for 1500 variables would take forever and Table.Profile wouldn't give me all of the stats + Box Plot that I need. Any suggestions?

Thank you

[mahoneypat]

If you have that many, you could make a custom function that takes a table as an input and returns all the stats for the table (similar to Table.Profile but customize to add what you need).  You could also do it with R or Python.  In any case, you can apply the function at the dataset level (when all the tables are still in table form) and apply the function; you would then have a single table with all the desired stats for all the columns of all the tables (that you could make your box plot from and have slicers for tables/columns).

Create a Profiling Report in Power BI: Give the End User Information about the Data - RADACAD

Pat

[helalm]

Thank you Pat,

I think I can add, as you suggested, few additional stats but getting but I doubt that custom Table.Profile give me reports like the ones I shared with pictures. Would it?

Thank you,

Helal