Forum Discussion

anon88's avatar
anon88
New Member
3 years ago

Variance between measures

 I have prepared a matrix table in PowerBI desktop which looks like the table below. However, each of the rows are measures e.g., net sales is a measure, staff salaries is a measure. I'd now like to add a column that calcuates the difference between the forecast and actual value. How can this be done? 

 

To use each of the measures as rows I've used the "Switch Values to Rows" option. 

 

 

Need Help

1 Reply

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    3 years ago

    Hi anon88 

     

    Can you please share some dummy data of the table you have? Does it have a column listing "Actuals" and "Forecast" values? If "Actuals" and "Forecast" are from a column, I'm afraid this may not be possible in a Matrix visual. We may need to create a new table to help hold the measures. Without data I cannot give any detailed suggestions. 

     

    Best Regards,
    Community Support Team _ Jing