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
Hi all,
I have a matrix table Ilike below:
Company 1 Company2
2021 2022 2021 2022
MEASURE1 x% x% x% x%
MEASURE2 x% x% x% x%
MEASURE3 x% x% x% x%
And I wish to add a variance column so the table will become like:
Company 1 Company2
2021 2022 YoY Var 2021 2022 YoY Var
MEASURE1 x% x% y% x% x% y%
MEASURE2 x% x% y% x% x% y%
MEASURE3 x% x% y% x% x% y%
Is this possible? I know a Measure can not be shown in Column so can't think of any way to create this variance column.
I'm thinking to convert these measures into a column (i.e. each measure becomes a row of this column), not sure if it's possible via DAX?
Thank you in advance!
Hi @ressul ,
Could you please provide the formulas about measures so that I can convert it to column form for you.
If it is possible, please provide your pbix file without privacy inforamtion and desired output.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi:
They have changed some formatting options. If you go to "Values" you can accomplish mesures on row. Please see image. Thanks..
Hi @ressul
you can use the columns subtotal to disply this value by editing the code of the same measures
User | Count |
---|---|
12 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
19 | |
14 | |
10 | |
7 |