Forum Discussion
Measure to Substract values from differents rows and columns in a table
Hello to everyone, i have a problem, i need to substract/sum 2 values from different rows and columns.
I have this inventory table
I need a measure because my data is very big. Also I have an index column but this is a summary filtered table table of all A and B items movements.
Thanks
Hi AMDU
You can use the offset function please refer to the tutorial:https://www.youtube.com/watch?v=C3QY0DWts8w&t=6s
Also, you can download my PBIX with the example:
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi AMDU
If a calculated column is not an option take a look at the linked discussion :
in your scenario, you can modify it to the index column
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
I don't think so...
If your data so large , it seems you need to do some preperations from the source...
7 Replies
- Ritaf1983
Super User
Hi AMDU
You can use the offset function please refer to the tutorial:https://www.youtube.com/watch?v=C3QY0DWts8w&t=6s
Also, you can download my PBIX with the example:
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Thank you very much for answering Rita, i just checked the example and the problem i have is that i only want to calculate the substraction for A and B products and i have more and when i filter them the position change, lets say from "A and B" to "F and Z", so i need to have a fixed reference between these 2. But this offset function will help me a lot for other files, thank you again!
