Forum Discussion
Variance Column
Hi Anonymous ,
You will need a disconnected table and some advanced DAX for that. In the attached example, In-Progress is not a row in Brand Sold column but in Status but by using a disconnected table and measures, i've made it appear so.
Please see attached pbix for your reference.
The accepted DAX solution works, but note that every time you add a new metric (Orders, Sales, OI, ROS like in your case) you need to duplicate the entire measure set. With 4 metrics that's already 8+ measures to maintain.
An alternative worth knowing: Flexa Tables (AppSource) lets you add a variance column between any two periods directly in the published report — no DAX, no Desktop access. End users select the two periods themselves. Works well for exactly this Actuals vs Plan matrix layout.