Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Power BI community 🙂
I have a matrix table with 3 columns
What I would like to do is add a third column with % varaince between column 2 & 3
Would someone mind explaining have a I can do this why an expression?
Many thanks in advance
Solved! Go to Solution.
HI @JayKarim ,
You can try below code:-
variance =
VAR result =
DIVIDE (
( [Total Sales £) YOA 2021] - [(Total Sales £) YOA 2020] ),
[(Total Sales £) YOA 2020]
)
RETURN
FORMAT ( result, "PERCENTAGE" )
Note- I am considering you have created a measure for the calculation of (Total Sales £) YOA 2020,(Total Sales £) YOA 2021
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Hi Samarth,
This worked 🙂 Thank you so much
Jay
HI @JayKarim ,
You can try below code:-
variance =
VAR result =
DIVIDE (
( [Total Sales £) YOA 2021] - [(Total Sales £) YOA 2020] ),
[(Total Sales £) YOA 2020]
)
RETURN
FORMAT ( result, "PERCENTAGE" )
Note- I am considering you have created a measure for the calculation of (Total Sales £) YOA 2020,(Total Sales £) YOA 2021
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
60 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |