Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper I
Helper I

Subtract columns from a matrix

The data in the matrix is count of salesid which is not a number, I can do what I need to do in excel by just reverencing the cells I need but I can't seem figure out how to do the same in BI. Please see the image enclosed to see what I"m trying to do. The 18v17 & per person needs to be seperate columns. Thanks.Capture.PNG

Community Support
Community Support

Hi @ShawnPrice,


I'm not so clear for your requirement, can you please share some sample data with expected result for test and coding formula?



Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Above is what I want it to look like but I'll post a test file. Thanks

Helpful resources


Fabric certifications survey

Certification feedback opportunity for the community.


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.