Forum Discussion

JorgeCervantes's avatar
JorgeCervantes
Frequent Visitor
1 year ago
Solved

I need help displaying information over a Matrix Table

Hi Everyone,    I hope to find you all well, I have the following table:   Part Number Last Price Standard Price Volume Balance Part 1 10 9 10 -10 Part 2 11 13 15 30 Par...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi JorgeCervantes ,

     

    As far as I know, if the [Month] column is related to your data table, the balance measure should work. You can also try SUMX() function.

    Balance = SUMX('Table',('Table'[Standard Price] - 'Table'[Last Price]) * 'Table'[Volume])

    My Sample:

    Result is as below.

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi JorgeCervantes ,

 

As far as I know, if the [Month] column is related to your data table, the balance measure should work. You can also try SUMX() function.

Balance = SUMX('Table',('Table'[Standard Price] - 'Table'[Last Price]) * 'Table'[Volume])

My Sample:

Result is as below.

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.