Min, max, average, ecartype, standard deviation and Variance in a summarized table

[rostromarre]

Hello experts,

I don't have too much time working with Power BI and i have a question regarding summarising table  (maybe my problem is more simple than I think).

I have a table with multiples colums, each one with multiples values in a period of time. I want to create a one single table (visual chart) with the resume of the min, max, variance, average and deviation of each colum.

This is what i did:
1. I created a calculated colum for min, max and average of each colum in my main table
2. I created a summarized table to put all the calculated values in a single chart, using a UNION

Totaux =
UNION(
SUMMARIZE (
    'STATIS';
    "Valeurs"; "MAX";
    "CPU Max"; 'STATIS'[Max CPU MAX];
    "Reboot";'STATIS'[Max Reboot];
    "GPS OK";'STATIS'[Max GPS OK];
    "GPS KO";'STATIS'[Max GPS KO]
        );
SUMMARIZE (
    'STATIS';
    "Valeurs"; "MIN";
    "CPU Max"; 'STATIS'[Min CPU MAX];
    "Reboot";'STATIS'[Min Reboot];
    "GPS OK";'STATIS'[Min GPS OK];
    "GPS KO";'STATIS'[Min GPS KO]
           )    
            )

My problem:  Power BI doesn't allow me to "JOIN" more than Two  rows, and I still need to create rows for variance, average and standard deviation.

Any ideas?... thanks in advance for your help

[v-frfei-msft]

Hi @rostromarre,

I think you needn't to create a a summarized table here. You can create measures to work on it. Could you please share your sample data and excepted result to me.

Regards,

Frank

[rostromarre]

Actually i created measures for each value, mu problem is to put everything in one single chart...

I still looking for a solution. I really appreciate if someone can give me some advises.

thanks in advance.

[rostromarre]

Hello @v-frfei-msft

My answer below...

Thanks in advance for your help.

[rostromarre]

Hello @v-frfei-msft

Thanks for your reply!

This is my sample date:

After selected a period of time (using a filter on the champ date),  the repport must show the table below:

Thanks in advance for your help