Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Variance Column

I have a matrix set up like this   company           2023           2024 4+8       2024 5+7   Orders Sales OI ROS     But I want a variance column measuring the difference from 5+7 to 4+8. ...
Need Help
  • danextian's avatar
    danextian
    2 years ago

    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.

     

     

danextian's avatar
danextian
Super User
2 years ago

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.