Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
hi all
Below is a matrix that has values for three distinct columns "ACT" "LY" "RF4", the 3 columns are selected filters from the same column of the source data. I want to calculate the difference between 1) ACT and LY, 2) LY and RF4. How do I insert the calculated columns into this matrix that is currently filtered?
Any help (with step by step visuals) is appreciated as I do not have much experience with DAX.
Thanks
Hi @teomelis,
Please refer to my reply in this similar thread: How can I calculate % from 2 columns 1 and 2 where 1,2 are the periods of time (year, months, etc)
We can add the Difference column into matrix, but it is not possible to dynamically show/hide the column based on slicer selection.
Regards,
Yuliana Gu
Create 2 calculated columns:
1. To calculate difference between ACT and LY
2. To calculate difference between LY and RF4
User | Count |
---|---|
84 | |
76 | |
74 | |
48 | |
39 |
User | Count |
---|---|
114 | |
56 | |
51 | |
42 | |
42 |