Forum Discussion
ACCUMULATE CALCULATION
I have de following matrix with 2 Orders (A and B) with 2 lines of material per line HOW TO CREATE THE "Total of Order" COLUMN THAT HAS IN EACH LINE THE TOTAL VALUE OF THE ORDER THAT IS EQUAL TO ...
Anonymous ,
A new column
Sumx(filter(table, [Order] = earlier([Order])),[Value])
a new measure
Sumx(filter(allselected(table), [Order] = max([Order])),[Value])
Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8
amitchandak
Super User
Super UserAnonymous ,
A new column
Sumx(filter(table, [Order] = earlier([Order])),[Value])
a new measure
Sumx(filter(allselected(table), [Order] = max([Order])),[Value])
Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8
THANK YOU FOR YOUR HELP