Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
i have table name called PO compliance
Thats table have three column
Month PO
May Within
May Within
May oVer
May Within
June Within
June Within
June oVer
June Within
July Within
July Within
July oVer
July Within
@amitchandak i have month wise count PO values. now i have only three months may,june,july. i want percentatge month wise not a over all ..
@Anonymous , Your current table at last is
divide(count(Table[PO]), calculate(count(Table[PO]), allexcept(Table, Table[Month])))
Can you share the expected output.
If you need June, July together , you need a new column
Month1 = if([Month] ="May", "May", "Other")
divide(count(Table[PO]), calculate(count(Table[PO]), allexcept(Table, Table[Month1])))
User | Count |
---|---|
12 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
19 | |
14 | |
10 | |
7 |